Compare Date with Current Date using SQL in MS Acc

问题:

I have a table in ms access 2013. It has a column name expirydate having date values. I need to write a query with the following condition expirydate is greater than current date. Can anyone tell me how can i do this?

回答1:

I'm supposing that you can use SQL query :

SELECT * FROM table_name WHERE expirydate > Date()