Date query for the past 2 weeks

[burrina]

I need the dates between now and the past 14 days.



will this work?

<14 And Date()

[Bob Fitz]

Perhaps you could use the DateDiff() function in the criteria row of a query

[JoeM]

Between (Date()-14) And Date()

[wnicole]

I tried this but was wondering how do I write this in an IIF statement.
I want to get a text field going for example:
IIF Between (Date()+7) And Date() THEN "Certification Alert"

Can you assist?

[JoeM]

The answer I gave was an answer to be used in the Criteria section of a query, not a calculated field. If you would like to do the same thing in a calculated field, you would do something like:

Expr1: IIF(([SomeDateField] >= Date()) AND ([SomeDateField] <= Date()+7),"Certification Alert","")