I'm trying to resolve a bug in a archaic reporting tool that generates SQL dynamically and I'm running to a problem where I get a Data type mismatch error when the generated SQL queries a Date field from a Dbase table.

I've managed to replicate the same problem in a simple test app where the below query is loaded into a TADOQuery and activated.

```
SELECT *
FROM [QPERFSAL.DBF] QPERFSAL
WHERE  ( QPERFSAL.PERFDATE = '21/01/2014' )

```

its obviously related to the date formatting but I've tried numerous formats but I still get the error
e.g. dd/mm/yyyy, mm/dd/yyyy, yyyy/mm/dd etc.

The obvious fix would be to used parameterised queries but as this is generated on the fly by a report tool, I can't use parameters :(

Is there something I'm missing or can I specify the date format at the ADO connection?

Thanks!