using not syntax in record selection crystal reports

Question

Pardon my ignorance in advance, I'm a complete novice at Crystal Reports.

I need to select all records where a specific field (employee.term_date) is null. I don't seem to be able to use ISNULL with a date/time field.

The following will select all records that contain a value in employee.term_date, but I am looking for the opposite - all records where this field is null.

Is there any easy way to use NOT in the statement below, or is there a better way to accomplish this?

{employee.term_date} > DateTime(1900,1,1,0,0,0)

Thanks in advance for any assistance!

Answer 1

Try below way

Not(CStr({employee.term_date}) like "")

Note: Not a tested condition...