IIF statement in Date calculations

[wnicole]

I tried this Between (Date()+7) And Date()

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?

[June7]

IIf is a function used in expressions. If Then is conditional code structure used in VBA and macros.

Where do you want this? In a query:

SELECT *, IIf([fieldname] Between Date() And Date() + 7, "Certification Alert", Null) AS Status FROM tablename;