That's what the ODBC driver is returning. It has nothing to do with Crystal. You'll have to write a formula in Crystal to look for that specific date and then make it blank.
>ODBC with a system DSN. I toggled the NULL setting in the properties of the DSN. It didn't seem to make a difference. If I set the select in Crystal to any value for the date field I get the 12/30/1899 date that I expect for a NULL.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer