Comparing dates in crystal syntax

[khayr]

Hello,

I'm trying to build a query that returns records where the date field has not been set. What do I compare the date to?

i.e. date = ????

empty string '' does not work, nor does null.

Thanks.

 

[synapsevampire]

This is database/column dependent, which you didn't share.

If it hasn't been set, then using the following might work:

isnull({table.field})

Or you might use something like:

trim(totext({table.field})) = "", but the performance might suffer.

Or

totext({table.field})) = " / / "

Is the field nullable? What type of database? WHat type of field, a date or a datetime?

-k