James,
a SWAG,
I suspect that CR evalutates Date (00/00/00) to something else than within VFP.
Did you try the ISNULL() function:
ISNULL(MC.DATE_CERT)
Walter,
>Hello All,
>
>What seesm to be simple is not coming easily to me. I'm trying to create a formula for filtering records in a crystal report to show only those with no date in a date field.
>
>This doesn't work:
>{MC.DATE_CERT} = Date (0, 0, 0)
>
>{MC.DATE_CERT} = Date (00/00/00)
>
>plus a million other tries, this is frustrating and I can't seem to locate anything in the help files that show an example of filtering for no date in a date field.
>
>Any help would really be appreciated.
>
>Jim Harvey
>
jharvey@netrax.net