Date Validation Current Date / Past 45 Days / Null OK

[Jani]

I'm using the field properties in a form and need to validate that the date
entered is not in the future and not more than 45 days past current date, and
the field can also be left blank. Here's my latest attempt which is not
correct either - allows any date to be entered. Please help! Thank you! Jani

Is Null Or <=Date() Or >=Date()-45

 

[bcap]

Is Null Or (<=Date() And >=Date()-45)

 

[Jani]

Worked great - thanks for the very quick reply. jms