Walter,

Yes the isnull(mc.date_cert) worked after I found that the "Convert NULL field value to default" has to be unchecked.

This is under File, Report Options, General settings.

Thanks everyone, for the help.

Jim




>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,
>