date control functions

  • Thread starter Thread starter CallGlen
  • Start date Start date
C

CallGlen

I want to use a delete query to automatically delete information 4 years old.
Is there something I can type into the "<now()" criteria to specify four
years?
Glen Longstreet
 
You can use the DateAdd() function:
<DateAdd("yyyy",-4,now())
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non working samsung tablet. 3
Calendar Date 4
Is there a way to delete multiple queries at the same time? 2
Parameters to search between years 2
query date criteria 1
First function returning min 4
Query for previous week, Sun thru Sat, from date field 1
How to filter on calculated dates 3

Back
Top