Date Critieria

[cruzer]

I need some help.
I need to retreive records in a report 60 days old from the current date, using the Date Visited field in the query. I would greatly appreciate the help.

 

[MikeAngelastro]

Where clause =

WHERE Date is Between Now() and Now() - 60

 

[Mile-O]

Between Date And DateAdd("d", -60, Date)