Date reversal

[Tom]

I don't know - maybe this is a Windows XP question but
her goes.
I am using an American version of Access overseas where
they use the British date system (dd/mm/yyy).
The computers themselves are set to use the British
format (the International hive for each user is set to
use the sDate of dd/mm/yyy).
What is happening is when they enter the date in the
British format it either comes back as the American
format or it gets all messed up. For example:
Enter 25-09-03 (The British format for September 25,
2003) what you get is 03/09/2025
Enter 03-10-03 (The British format for today October 3)
you get 10/03/2003.
Now - if you enter the date in the American format e.g.
09-25-03 it comes back correct - 25/09/2003.
Any ideas? I really don't want to have to program every
form in every place where dates are entered if I can get
around that (of course I guess I could make a funtion but
I am hoping there is an easier, and less system intensive
solution).
Thanks in advance.
Tom

 

[Matt Weyland]

This can be approached from a couple different approaches.

1. Create a function to translate the date from US
standard (mm/dd/yyyy) to British (dd/mm/yyyy)

2. Change the system settings on all of the PCs to a
standard format throught the control panel.

HTH.

MW

mweyland at mnqio dot sdps dot org

 

[Tom]

Yes I know I can do it with a function, but the hassle
there is to go back through every form, every query,
every report... you get the idea, and reference the
funtcion.
All of the machines already have their Regional settings
to the UK date format, that's what makes this so weird.
Even weirder - some machines work fine - enter the date
in UK format and it stays that way, some do what was
originally described.
Any other ideas? Anyone else ever had this?
Tom

 

[Allen Browne]

Tom, take a look at:
International Dates in Access
at:
http://allenbrowne.com/ser-36.html

The article is based on 11 years experience with Access in a d/m/y setting.