>>It looks you'll need to give me a hint. I'm still not getting anywhere.
>
>The way I've been able to do is to test for the field value against Date(1899,12,30). Checking for null values using IsNull() will not help at all since, as Craig pointed out, the ODBC driver is returning an actual value.
>
>Laterness,
>Jon
Here's what I am doing currently. Report has 3 fields--item number, description, and date out (just so I can see what I'm getting). Base report with only a sort ASC on the date out and item status of 'OUT' gives me a return of 61,000 plus records. On the preview screen the first several rows are showing a date out of 12/30/1899. I then go into select and choose the date out field and set it 'equal to' and put in 12/30/1899. If I look at the formula that Crystal generates is shows

{cdm20itm.itm_stats} = "OUT" and
{cdm20itm.itm_ddate} = Date (1899, 12, 30)

This returns no records. I must not be testing correctly and that is why I need a hint.

But as usual, while typing this post I had an idea.

cstr({cdm20itm.itm_ddate}) = "12/30/1899" and
{cdm20itm.itm_stats} = "OUT"

This gave me what I wanted. Thanks to Jon, Bill and Craig for all the pointers.