[AccessD] Date standardization

That's why I simply never let users type a date. They always get a calendar form where it is patently obvious what date they are choosing.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, June 18, 2010 1:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Date standardization

Hi Doug:

I do a lot of government work, in Canada and they only accept dd Mmm yyyy (i.e. 12 May 2010; no confusion and a sequential order) or yyyy mm dd (Federal government, banking and SI standard and sorts as easily in date or text format). The mm dd yyyy format (and has been the bane of my existance as I never know whether I am looking at 10 May 2009 or 05 Oct 2009), I think it is a US default.

You are just dealing with the wrong customers and have not followed me in a project as I convert everything I can... that is one of my missions in life.

Jim

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Friday, June 18, 2010 7:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date standardization

I've had three different problems with the regional date format (I'm in Canada which mostly uses the mm/dd/yy format):

1. An engineer who decided that the logical display was yy/mm/dd, and who just got annoyed when people complained that the dates on his reports were crazy.
2. Similarly, an English manager who insisted on dd/mm/yy when everyone else in the office (and all his suppliers, customers, etc) wanted to use mm/dd/yy.
3. The Windows install - there is a standard option somewhere that assumes that Canadian users want the English dd/mm/yy display.  Many users never notice that the display is non-standard, and if they do, have no clue how to change it.  I've heard the remark "Yes, now that you mention it, the date on my computer is always wrong" several times.

Doug

On Fri, Jun 18, 2010 at 2:36 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi Steve
>
> > The import routine didn't 'know' which format the dates were 
> > originally
> created in ..
>
> which means that you, the developer, were misinformed.
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com