At 11:09 PM 23/08/2005 +1000, you wrote:

> > Hi all
> >
> > Is only American style of date allowed to be passed to an SQL
> > statement?
> >
> > My VFP app uses British style of date dd/mm/yyyy and I was not able to
> > query using SQL Pass Through.
> >
> > As soon as I queried using mm/dd/yyyy I got the results.
> >
> > Can I pass date in the format yyyymmdd (didn't work for me), or
> > something that does not rely on particular date format, something
> > generic.
> >
> > Please advise.
> >
>
>Aug 23, 2005

Also '2005-08-23' or '23.08.2005' or 23-Aug-2005' (plus quite a few
others). Just never 'dd/mm/ccyy' since it will either store the wrong date
or throw an exception. '23/08/2005' prompts an exception because there is
no month 23; '12/08/2005' stores "eighth of December".

./hb