Access and Daye Formats

[Guest]

Is there any way to make Access overrife the computer regional settings for
date formats. I am having problems with mdbs using Canadian date formats
DD/MM/YYYY when installed on systems that have US date formats in regional
settings MM/DD/YYYY. A lot of Canadians it seems simply leave the US
defaults on preinstalled Windows and it causes dates to be screwed up.

Any help appreciated.

Thank you.

Ray

 

[Allen Browne]

Ray, take a look at:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
It discusses the 3 cases where Access is likely to misunderstand our d/m/y
date settings.

IMHO, an Access developer has no right modifying the user's formats,
particularly formats that apply to other software as well.

 

[Larry Daugherty]

Format(DateVariable, "formatstring")

HTH