Swapping month & day in dates

  • Thread starter Thread starter James & Darla Martin
  • Start date Start date
J

James & Darla Martin

Hello all,

This is a pretty common problem, but I just wanted to make sure of
something.

I have a database that is designed to use dates in the format mm/dd/yyyy.
The format on all the date fields on forms is mm\/dd\/yyyy. No problems ...
everything is fine and happy. But now we have a user whose date format in
Regional Settings is dd/mm/yyyy. Whenever he enters a date like 04/01/2004
(which should be April 1) and exits the control, Access "helpfully" spins
his date around to 01/04/2004 (which is January 4). All of the other users
have their Regional Settings set to mm/dd/yyyy and have no problems.

Is there a way to tell Access to knock it off? (RANT: every Intellisense
feature should be optional ... because half of them are intellinonsense.)

Or do I just have to tell the user he has to live with a) changing the
format in Regional Settings, or b) entering his dates backwards and watching
Access spin them into the proper format for him.

James
 
Totally agree with your rant, but there is no way to turn this nonsense off.

In practice, it's even worse than you suggest. This year, if a user types
2/29
into a date field, they get 2/29/2004. Next year they will get 2/1/2029.

Can't solve that one for you, but this article adddresses 3 other areas
where Access can get your date wrong:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
 
Back
Top