[AccessD] Entering an ISO date with input mask and full validation

Gustav Brock gustav at cactus.dk
Thu Jan 14 07:53:39 CST 2016


Hi Lambert

Sweden also uses the yyyy-mm-dd format widely, and here it is an official and recommended standard but very few uses it - most stick to the old dd-mm-yyyy format.

The yyyy-dd-mm seems just too odd to me.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Heenan, Lambert
Sendt: 14. januar 2016 14:46
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Entering an ISO date with input mask and full validation

Like you say Gustav, it's the illogical mm/dd/yyyy here in the USA.  AFIK only the Japanese have a sensible date format - yyyy-mm-dd - allowing for chronological sorting of string date values.

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 14, 2016 4:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Entering an ISO date with input mask and full validation

Hi all

I received a reader comment on this, claiming that "the US uses yyyy-dd-mm format".

This is new to me. I have never seen anything else than mm/dd/yyyy for date formats related to the US.
Can anyone confirm the use of the yyyy-dd-mm format?

/gustav 



More information about the AccessD mailing list