Comparing Dates

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi,

I want to make a query that compares a date field I have
in my records with today's date and then pull out all the
records that are 2 or more weeks old. I think I need to
use the DateDiff function in the criteria of my query but
I can't figure out how to do it.

Any help would be appreciated.

Cheers

Martin
 
DateAdd will work or, because of the way dates are handled, you could just
subtract 14. Place your date field in the query and for that fields criteria
use

<= Date() - 14
or
<= DateAdd("d", -14, Date())
or
<= DateAdd("ww", -2, Date())
 

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

Query - pull past 12 months 1
Pull Out within 30 days of a today's date 2
Query date range 4
Compare and check date 2
Generating system date in Query 2
Access Compare records in same access table 0
Date Difference limited to 100 years 6
Compare date to previous date to see if 6 weeks have past 8

Back
Top