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?
Code:If ComplaintDate > "1/1/2022" Then msgbox "Message" End If