Date formats

[48Highlander]

I am in Canada and so I created this system with the Regional short date setting of dd/mm/yyyy. Because of the potential for confusion over date formats, many of my controls have the format property set to "medium." (Displays as 04-Mar-2010) One of my users wants to be able to use a short date format of mm/dd/yyyy. To test out the implications, I changed the country from Canada to US and selected a short date setting of mm/dd/yyyy. Wherever I see a short or a long date, the format is correct. However, the dates formated as "medium date" are still in the Canadian medium format 04-Mar-2010. The help file says that Access uses the short, medium and long date formats set in the Regional settings. I can see a short date and a long date in the Regional settings but no "medium date." Anybody got a clue?

Bill J

 

[SkipVought]

Hi,

A Date FORMAT is just that: a FORMAT. Changing the format have absolutely no effect on the underlying data which is NUMERIC. The FORMAT is just how you want to see the data in the table.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

As Skip suggested all dates are stored in your tables exactly the same (as a number). The date/time at this moment is about 40241.3504398148. Medium date is the same in the U.S. as Canada.

Duane
Hook'D on Access
MS Access MVP

 

[48Highlander]

Thanks Skip and Duane. I knew that dates were stored as a number. What was throwing me is that there was no change in the format of medium dates when I switched my Regional Settings from Canada to the US. I had anticipated that the medium date format would have changed as well. How anyone would have known that the medium format would be the same for both countries is beyond me. I spent over an hour looking to find a definition of medium date on the Microsoft websites. I guess it takes a genius like Duane to have learned such an arcane fact. <g>

Bill J