Hi! I am fairly new and appreciate any help here! I am trying to apply conditional formatting in a form to highlight any records in a field called ExpirationDate2 that will expire before 11/30 of the current year. The expression I am using is: Value < CDate("11/30/" & Year(Date$()))
While that expression is working just fine in other date fields, ExpirationDate2 is formatting dates incorrectly. I suspect this is because it is a text field that is actually calculated in a query, since not all records expire (I made a separate field for those called "Open"). This is the expression from the query:
ExpirationDate2: IIf([Open]=False,[ExpirationDate],"Open")
Is there a way to specify that conditional formatting should only apply to certain values (those that look like dates, even though they are stored as text)?