Dateadd in a query

[markwmiller via AccessMonster.com]

I have a query that I want to find records 6 years old. How would I use the
dateadd function without any user input.

 

[fredg]

I have a query that I want to find records 6 years old. How would I use the
dateadd function without any user input.

Exactly 6 years to the day, ONLY?
as criteria on the date field column, write
DateAdd("yyyy",-6,Date())

More than 6 years from this day?
as criteria on the date field column, write
<=DateAdd("yyyy",-6,Date())

 

[markwmiller via AccessMonster.com]

Thanks, I should have known that. Been a long week.