Comparing todays date -14 days from the date created in the db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone

I'm trying to write a query that takes todays date -14 then searches the db for all the emails that have been created in 14 days from todays date

thank
L
 
if what you're asking is to get all the records in a table where the value
in a date field is between today and 14 days prior, then try this in the
query's date field criteria:

Between DateAdd("d", -14, Date()) And Date()

hth


Lilly said:
Hello everyone,

I'm trying to write a query that takes todays date -14 then searches the
Click to expand...
db for all the emails that have been created in 14 days from todays date.
 
Back
Top