Select by "Null" Value

[Kibeth]

I have a report that I need to see only the results that have a null value in the "Ship" field. I have tried having Crystal convert the Null values to default, but it doesn't seem to be working. The Ship field is a date-time field, and no matter what I put in the Select Expert it says I need to enter a date-time format. Can someone please help me with this? I'm not sure what other information to provide.

Using CR XI

 

[synapsevampire]

Goto Report->Selection Formulas->Record and place:

isnull({table.field})

Turn off the convert null values to default.

-k

 

[Kibeth]

Thank you! That worked.