At 05:11 PM 21/07/2006, you wrote:

>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"

Yup, Firebird doesn't recognise a date literal in the format
"dd/mm/yyyy" - it always interprets that format as "mm/dd/yyyy" and
of course there is no month 21, hence the exception!

Find a way to decode the date into a format that is accepted. Here are some:

dd-Mmm-yyyy
dd.mm.yyyy
yyyymmdd
yyyy-mm-dd

Even dd Mmm yyyy should work ok.

./heLen

>Does anyone have a fix for this?
>
>Thanks,
>John
>
>
>
>
>
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>