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