How to omit a record when the Date field is not empty ?
When I perform a Find, how do I omit a record when the "Date" field is not empty?
I tried to put @ in the "Date" field, but I got the following message:
The value of this field must be a valid date in the range of years 1 to 4000 and should look like “12/25/2003”
Can anyone help me with this?
It is sometimes easier to do this kind of step backwards:
Manually, Find for "*" in the date field, then choose "Show Omitted Only" from the drop down menu
Scripted, Enter Find Mode, Setfield to "*" then omit record.
Either way, find what you DONT want, then reverse the find.