Solved Date() function in Query

[Momma]

I'm using >Date() function in a query to display records greater than today's date. It results in zero records.
What am I doing wrong?

 

[Gasman]

Works for me?
You do have records that satisfy the criteria, don't you?

 

[Momma]

Works for me?
You do have records that satisfy the criteria, don't you?

It worked before and I couldn't see what went wrong. I imported the query again from a previous backup and it's working now.
Thank you!

 

[Gasman]

It worked before and I couldn't see what went wrong. I imported the query again from a previous backup and it's working now.
Thank you!

You never said it worked before?

If something has worked before and suddenly stops working, aside from MS bugs, check the data.