"Frank_Hamersley" wrote ...

"Jamie Collins" wrote
From testing I've conluded that seems Jet 4.0 gives entirely
consistent results using ISO-8601 standard date format, being
yyyy-mm-dd

I should qualify my comment in saying it springs from VBA Excel and the date
formats of "yyyy.mm.dd" which I generally consider as European (esp with the
period sep char) and Asian (well mainland China at least), "mm/dd/yyyy" as
North American and "dd/mm/yyyy" for Commonwealth countries (generally).

And ISO-8601 is the international standard which should cover all the
above (including North America <g).

However, for peace of mind using an unambiguous date format can be good

strStartDate = Format$(datStartDate, "dd mmm yyyy")

I agree 100% - especially when crossing over to different vendors products!

There could be problems with differing regional settings on the client
and server machines e.g. '01 MAI 2004' produced on a French language
machine will not be recognized as a date on an English language
machine.

Jamie.

--