Jim Lawrence
accessd at shaw.ca
Fri Apr 1 10:47:26 CDT 2011
It was a date format for human viewing; a number delimitated by letters and then numbers again...found to be the best standard and for easy reading, because of its symmetry and order. OTOH if given a date like 03/06/11, no one will ever know whether it is referring to the Mar 06 1911 or 03 Jun 1911 or Mar 06 2011 or 03 Jun 2011. Worked on a government project to bring all the old data into the computers. When I left 6 months later they were still working on it. With no standards and mixed formats many dates had to be interpeted by manually going through related files. I understand that people are still working on the project and that was almost 15 years ago. ;-) We know of a friend who is tasked with translating of church records which go back over a thousand years...too bad there were no stanadrds in the parishes. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, March 31, 2011 10:31 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Un-American Date Filter dd Mmm yyyy .... in sequential order. (?) You mean "01 Apr 2011" comes before "01 Jan 2011" in your calendar? -- Stuart On 31 Mar 2011 at 21:54, Jim Lawrence wrote: > Actually, our government (federal and provincial) uses yyyymmdd which > sorts as a string, a number or as a date without any translation. The > other date standard they use is dd Mmm yyyy; ie. 01 May 2011 so there > is never any confusion between month and day...and again everything is > in sequential order. > > Jim > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com