I am a new Crystal user and am trying to select only records that have a null date field i.e. only those records that have "closed date" = null.
I have tried the following but it removes all records. In my data I have 10 records with no closed date and a couple with a closed date.
and isnull({wkrofile.closed_date})
Please help.