I have an update query where I want to find anyone whose MemberStatus is 1 AND who enquired more than 180 days before today, then update their status to 4. The date field -DateEnquired - is set to Short Date. The Criteria is <Date()-180. This returns an error message.
What am I missing? UPDATE-BASED-ON-DATE.JPG