When I use the Ole DB provider for Visual Foxpro within Crystal reports, I get an error when using a date field. The error message contains the following:

Failed to retrieve data from the database.
Details: ADO Error Code: 0x80004005
Source: MS Ole DB provider for Visual Foxpro
Description: SQL: COlumn 'DATETIME' is not found.
Native Error: 806

When I view the generated SQL select statement, it is taking the date field and performing the following:

`Schedule`.`sched_start`=CONVERT(DATETIME, '06-28-2007', 110)

Does anyone know if a work around for this?

Thanks you in advance.