The following is correct syntax for using ODBC 'Date type' in Crystal Reports.
<cfreport report="report.rpt">
{table1.DateField} = {d '1997-07-01'}
</cfreport>
or{table1.DateField} = {d '1997-07-01'}
</cfreport>
<cfreport report="report.rpt">
{table1.DateField} = Date(1997, 07, 01)
</cfreport>
{table1.DateField} = Date(1997, 07, 01)
</cfreport>