1/12/2010.
For reasons I am not completely aware of, actually, completely unaware of, there are two answers to this question depending on where you went to school. It’s either January 12th 2010 or 1st December 2010.
Surely it’s about time (bad pun) the world adopted a standard method for writing dates. I advocate that both the DD/MM/YYYY and MM/DD/YYYY can be improved upon using YYYY/MM/DD - the International Date Format. Some applications that use databases already subscribe to this method such as Apple’s Aperture and I’m sue there must be many more. Aperture is a file management and editing application for professional photographers. In the file structure images are organised into folders within folders within folders where the top folder is the year, the next folder in is the month and final folder is the day of the month. Images are individually numbers by the camera in either a standard 0001 sequence or precise time of shot in the HH:MM:SS format.
When naming files using YY/MM/DD there is no confusion about the date. The brain seems to automatically understand that you’re looking at the year, followed by the next smallest container, ie the month and then by the smallest container, ie the day. This is the same way time works. First the hour (the largest container), then the minute and finally the seconds. Why have we been treating years, months and days differently? A truly correct date and time should be YY/MM/DD HH:MM:SS. That precise instant in time can be understood by anybody with no room for error. Just like latitude and longitude have standards so that every navigator knows how to read a map, find their position and calculate a route. There is no ambiguity.
Who cares? What’s the big deal I hear you you ask. I can give you a real life example of where the DD/MM/YYYY and MM/DD/YYYY completely suck. I received a cheque a while back from an Australian company that was using US software to print its cheques. The software probably referred to them as checks. I received the cheque on 14th April and it was dated 4/11/09. Alarm bells ring. Sure enough when I presented it the bank in mid-April they read the date as 4th November 2009, considered it post dated and refused to accept it.
So I had to go back to the company and tell them the story to get another cheque issued. Perhaps it was just he particular teller at the particular branch of the particular bank I went to that didn’t want to put this cheque through but the company told me that no one else had had issues when banking their cheques. I did however persuade the accounts clerk to make the necessary change to their software; it was just a click in the preferences settings – no biggy!
But let’s look at some disaster scenarios which involve more than just me having to make a phone call and wait a couple of days to get my money. What if the expiration date on pharmaceutical supplies or drugs made in the US but being used in Australia had 10/11/2010 stamped on them, and the actual date was 15 Oct 2010. These supplies are either still good until 1o Nov or expired 11 Oct. Remember that some drugs become more active after their use by dates.
As I write this post I can see that WordPress is already creating a folder using YY/MM/DD in the database. When the data needs to be called back it can found much more easily.
Another solution which I am not a fan of would be to use the 2 or 3 letter abbreviation for each month instead of numbers. The above date would then be Jan 1, 2010 or 12 Dec 2010. That’s fine for visual representation but it won’t work with file nomenclature. Computers will only sort alphabetically as default when looking at file names in folder structures. Of course with file naming protocols the ‘/’ wouldn’t be used so the date would just be 20100101, 20100626, 20101225 etc. Using this format takes advantage of the inbuilt sorting methodology of all computer systems platforms to put the oldest at the top and the most recent at the bottom of any list of files.
So these three dates for example 1 Feb 2010, 1 Apr 2010 and 1 Dec, 2010, while in correct chronological order would appear in file order as 1 Apr, 2010, 1 Dec, 2010 and 1 Feb, 2010.
So give it a go. I believe if enough people start writing dates in this manner a groundswell will encourage institutions and government to adopt the standard. It must, or we wouldn’t have two standards right now.
IMHO, unless we adopt this standard soon we could face another Y2K style scenario as the need for the world’s databases merge over time. And the beginning of the year is the best time to start this movement.
So happy 2010/01/01 to you all.
UPDATE:
I found this website while looking for motorcycle porn (naked bikes, not naked women). These guys have already realised the importance of the YY/MM/DD format and incorporated it in their site. Check it out and tell me if you don’t think that the date format used is instantaneously recognisable. They are a Japanese company doing business in Europe. This kind of cross cultural, cross economy communication is where this new standard is needed most.
-33.862968
151.241097