Criteria for when today's date falls within date range. 1

[mark929]

I’m trying to set a Access2007 query criteria to return records when today’s date falls within a range of a database date field “Selection Made” + 14 days. I’m trying to get the records to show up in a report for 14 days after the date field “Selection Made” date. After the 14 days, the records would no longer appear on the report. I’ve tried several things without success and I’m ready to ask for help.

Any suggestions or input would be greatly appreciated.

Thanks

 

[SkipVought]

Hi,

I've tried several things without success

And the latest would be WHAT/

Please post your SQL.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[genomon]

Try adding BETWEEN to your SQL WHERE clause:

WHERE Date() BETWEEN SelectionMade AND DateAdd("d", 14, SelectionMade)

All I ask is a chance to prove that money can’t make me happy.

 

[mark929]

Thanks genomon,

I was trying the very inefficient 2-step approach of creating a new date field to calculate the date field + 14, and then using >and< on the old and new date fields. I haven’t used Access since 03. Thanks for the help and refresher.