It seems like this comes up alot. I have a date field, i created one column for days and one for month year. On the one for days i need all the days <=1 and >=15 but i am getting the error. If I remove it - no error if i put = 1 i get the error.
The statement is
ExDat: Format([ExtraDate],"dd")
Criteria: <=1 and >=15
The second one is
ExMthYr: Format([ExtraDate],"mm/yyy")
Criteria: =Format(Date(), "mm/yyyy")
It's the first one that giving the error.
This seems so simple