AnsweredAssumed Answered

Use of date fields and variables in finds

Question asked by PecCars on Feb 28, 2011
Latest reply on May 31, 2011 by margotjacqz

Title

Use of date fields and variables in finds

Post

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 ?

ScreenShotScript.JPG

Outcomes