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.