Use of date fields and variables in finds
1. I have a find that looks to omit empty records with a date field. If I use =, I get the error message that is not a valid date format. What is the correct criteria for omiting an empty date field ?
2. The same find uses a comparison in another date field in order to filter records, I am using a date variable > $$ThisMonth and compare it against the date field ThisRecordsDate. I get also the same error message for an invalid date format. What is the correct way of comparing a date field with a date variable in a find dialog ?