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]

Re: Regional Date Settings?

Karl Irvin wrote:[color=blue]
> 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.[/color]

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]