Why MM/DD/YYYY?

Being that I do a lot of stuff internationally through emails to several different continents, I always write it out like 3 April 2002, because if I say I’m flying in on 3/4/02 it can really become a mess.

More trivia. In Taiwan it’s 22 March 91 as they count from the overthrow of the Qing dynasty (the Last Emporer).

The military has taken care of this problem very well and rightly so as you wouldn’t want to be invading somewhere on the wrong day. It is always dd/(month written out, such as May, Jun, Jul, and so on)/yyyy. The is practically fool proof.

dcurt

Mangetout, if you’re interested, I can knock off a quick couple of Access functions for converting dates back and forth. My e-mail address should be in my profile.

I’m just a linguist-turned-database-programmer, but my guess for why it’s month, day, year is that most of the time, when people are dealing with dates, they’re working within one year’s time frame. For that matter, in a database I’m building at work, in a listbox where people can see the history of a set of transactions, I’m only displaying the month and date entered because the type of transaction I’m dealing with shouldn’t be active for more than one year. As a result, standard practice is just to say month and day. ie.

If more specific information is needed, the year is appended as a short subordinate clause:

Of course, this is talking about Americans from someone who was born in the UK, raised in the US, and self-identifies as both. Yes, I’m confused!:slight_smile:

CJ
BTW, Happy 40th, Mum & Dad!

If we’re talking logically, then D/M/Y or Y/M/D would make more sense (IMO), since it’s “small unit”, “larger unit”, “largest unit”, or vice versa.

i’m an american, and i follow the day-month-year format. although i started following that only a few years ago, after thinking “y’know, smallest to largest makes a lot more sense. small to medium to large, instead of medium to small to large”. but i write out the month as well, to avoid confusion (so my class notes friday had 22Mar02 or 22Mar2002).

most of my friends at uni are from other countries (predominantly poland and russia), and they appreciate someone who understands how they date their typed notes. when a friend needed notes for a lecture in november and said “lecture on 5/11”, i without hesitation went to my november files and got the right date. she said, “wow, i always have to correct myself with a date with everyone else, but someone gets it!” :smiley:

[hijack for FYI]
Dates in SQL and Access are stored as a ‘number of days since …’. The changes in regional settings, etc. only control HOW the dates are displayed.
[/hijack]

Bob

Sure, but an SQL queryof those is just a bit of text; the order in which you place the month and day in the WHERE clause is critical.

NO! We say “The 22nd ** of ** March”

Ode To Billie Joe" (Bobbie Gentry): “It was the third of June, another sleepy, dusty Delta day…”

D-Day is also often referred to as “the sixth of June”.