By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Regional Date Settings?

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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]

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.