[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