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

[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

 

[tina]

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

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.