>I believe it is the VFP ODBC driver that is returning blank dates as 12/30/1899. If you create formulas in Crystal to look for that date then you should be good to go.
>
>Laterness,
>Jon

Hi Jon,

I created a new formula field called "mdatecert" and in the formula editor I put in "date(1899,12,30)".

From there I went to the select expert and added the following:

{MC.DATE_CERT} = {@mcertdate}

The report still shows no records but I know there are several dozens where there is no date in the date_cert field.

Any ideas where I'm going wrong?

TIA

Jim