Hope someone can assist:

I am using MSQery to get data into excel from firebird 1.5 (using
firebird ODBC 2.0).

I can enter a fixed date in MSquery and the data is returned. If I
use a variable then the following error is returned:

Dynamic SQL Error
SQL error code = -303
Conversion error from string "[date/time]"

where [date/time] is the date entered followed by 00:00:00

eg: entering 21/07/2006 as the variable returns the string "2006-07-
21 00:00:00"

Does anyone have a fix for this?

Thanks,
John