Selection criteria by date calculation
Kind of new to Access. I am writing a query and want to bring back records with a date field that is less than 365 days prior to today's date. For example- On February 25, 2015, I want to bring back all records with a DATE_OPEN that is after
February 25, 2014. Suggestions, anybody?
February 23rd, 2015 6:11pm
Add the DATE_OPEN field to the query grid, if you haven't already done so.
Enter the following in the Criteria line of the DATE_OPEN:
>DateAdd("yyyy",-1,Date())
Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2015 6:22pm
This topic is archived. No further replies will be accepted.
Other recent topics
