At 10:24 AM 24/07/2006, you wrote:

> > 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
> >
> >
>
>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.
>
>Any other ideas?

Are you aware that you must enclose a date literal with apostrophes?

./heLen
http://docs.yahoo.com/info/terms/

>