How to exclude records in a query 60-days past the current date?

[djclntn]

Containing "Dates" in a query, if you don't want to view the records dated before say the month of July in the criteria box you'll put <#6/30/2011#.




However, what if you don't wish to see records 60-days past the current date I can't come up with the criteria which might be simple.

I tried <>Now()-60 in a query & it didn't work. Does anyone have any ideas/suggestions? I have both Queries & Forms.

Thanks

[djclntn]

I just figured if out immediately after posting.

It's >Now()-60

[RuralGuy]

...or Date() - 60. Now() includes the time. Date() sets the time to midnight.