I have converted an embedded database to MSSQL. I specified that Date should convert to Date (not DateTime). In this way the default value of Date is 01-01-0001.

Now my problem is I cannot select records with empty dates. I have tried this (and some more):
{Order.stopdate} = Date(1,1,1)
IsNull{Order.stopdate}

But I get nothing. It seems Crystal does not accept something like Date(1700,1,1). It must be at least Date(1753,1,1). Does Crystal work with another default value?

Any suggestions how I solve the problem?