Dateadd in a query

  • Thread starter markwmiller via AccessMonster.com
  • Start date
M

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.
 
F

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.
Click to expand...

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())
 
Top