Access and Daye Formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 23 Jul 2007 01:10 GMT

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

Reply to this Message

Allen Browne - 23 Jul 2007 02:29 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Is there any way to make Access overrife the computer regional settings
> for
[quoted text clipped - 8 lines]
>
> Ray

Reply to this Message

Larry Daugherty - 23 Jul 2007 02:29 GMT

Format(DateVariable, "formatstring")

HTH

Signature

-Larry-
--

> 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
[quoted text clipped - 7 lines]
>
> Ray

Reply to this Message