M markwmiller via AccessMonster.com Apr 21, 2006 #1 I have a query that I want to find records 6 years old. How would I use the dateadd function without any user input.
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 Apr 21, 2006 #2 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())
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())
M markwmiller via AccessMonster.com Apr 24, 2006 #3 Thanks, I should have known that. Been a long week.
