Set date to false after 3 months 1

[hdat44]

Hi i have a date field in my form and i want the date to be false after a 3 month period has expired i have tried the code below but the incorrect date just populates the field

If Date ,DateAdd("m",-3,Now()) Then
Date.Value=False
End If

Any help please??

 

[jrbarnett]

False isn't valid as a date value.
Did you mean null (blank)?

John

 

[hdat44]

Yes, Brilliant it worked thank you very much for your help!!

 

[jrbarnett]

Aother tip - replace Now() with Date() (to eliminate the time part of your code) and it will speed up a bit, unless the time component is needed for your program.

John