Help with if statement and date

[templeowls]

I'm trying to get a msgbox to appear in a form only if a date field is after a certain date. If the complaintdate is before 1/1/2022, I don't want the msgbox to appear. Below is my code, but it is not applying correctly. The msgbox appears regardless of the date. Any suggestions?

If ComplaintDate > "1/1/2022" Then msgbox "Message" End If

[Bob Fitz]

I'm trying to get a msgbox to appear in a form only if a date field is after a certain date. If the complaintdate is before 1/1/2022, I don't want the msgbox to appear. Below is my code, but it is not applying correctly. The msgbox appears regardless of the date. Any suggestions?

If ComplaintDate > "1/1/2022" Then msgbox "Message" End If

Perhaps:

If ComplaintDate > CDate("1/1/2022") Then
   msgbox "Message" 
End If

[templeowls]

That worked!! Thanks so much!!

[Micron]

if a date field is after a certain date

If it's really a date field, why pass a string to the logical test, only to convert it back to a date? Date data is delimited as #01/01/2022# If that wouldn't work, the field is text data type thus the conversion is needed.

[Bob Fitz]

That worked!! Thanks so much!!

Glad to help, if I can.

Can I ask which "event" you are using and what kind of message you will be giving?