johnbbishop wrote:

> Thanks for the thought - have already tried all these. Some return
> "Syntax Error in Date" (such as yyyymmdd, or dd-Mmm-yyyy) and others
> return the good old Error -303 (such as dd.mm.yyyy).
>
> The problem seems to be in MSQuery as it is MSQuery that returns the
> error, but I don't know if it is just MSQuery or the ODBC driver.

For odbc, you may use odbc escape sequence, like
'{d ' SQL_TYPE_DATE
'{t ' SQL_TYPE_TIME
'{ts' SQL_TYPE_TIMESTAMP

eg. "update acctfl set invoicedate = {d '2000-01-01'}" for date only field. The
odbc driver should translate to the correct format for you.

regards,
bill