Regional Date Settings?

[Karl Irvin]

My regional setting is English(United States)
My customers setting is French(Canada)

When he runs my program using a typed in date, he gets a "date invalid"
error.

Do I need to do something to dates in Access when the regional settings are
different?

The error may not be coming from Access but from a purchased module that
calls a dll routine.

[Trevor Best]

Karl Irvin wrote:

My regional setting is English(United States)
My customers setting is French(Canada)

When he runs my program using a typed in date, he gets a "date invalid"
error.

Do I need to do something to dates in Access when the regional settings are
different?

The error may not be coming from Access but from a purchased module that
calls a dll routine.

It maybe so, does your DLL take the date parameter as a string? You
might consider calling it with Format(date,"MM/DD/YYYY") to format it
back to US format.

Then get onto the vendor of your DLL and tell them to stop being
arrogant and accept dates in international format :-)

--
[Oo=w=oO]