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

[Dan Waters]

Actually no - I was referring to Year-Month-Day (yyyy-mm-dd) because it's
easily sortable.

Did you mean something about how Caps affect formatting?

Dan

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

Dan was referring to yyyy-DD-MM  :)

On 14 Jan 2016 at 14:38, Peter Hirons wrote:

> Actually, what doesn't make sense is the mm-dd-yyyy layout. When you 
> see 01-05-2016 you can't be sure if it's 5th Jan or 1st May that the 
> rest of the world would assume.
> 
> yyyy-mm-dd will be understood the world over and I, for one, would 
> like it universally adopted.  Even countries that do not normally use 
> the calendar based on some event around 2000 years ago will still 
> understand.
> 
> ---
> 
> 
> Peter
> 
> On 2016-01-14 14:13, Dan Waters wrote:
> > Hi Gustav,
> > 
> > This format doesn't make sense, but is the reverse of what is 
> > typically used in the US (mm-dd-yyyy).  I'm going to guess that 
> > someone had a momentary bout of dyslexia and just read it backwards.
> > 
> > I like using yyyy-mm-dd whenever I can just because it sorts 
> > correctly.
> > 
> > Dan
> > 
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On 
> > Behalf Of Gustav Brock Sent: Thursday, January 14, 2016 3: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
> > 
> > 
> > -----Oprindelig meddelelse-----
> > Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne 
> > af Gustav Brock Sendt: 1. januar 2016 19:47 Til: Access Developers 
> > discussion and problem solving <accessd at databaseadvisors.com> Emne:
> > Re: [AccessD] Entering an ISO date with input mask and full 
> > validation
> > 
> > Happy New Year to all.
> > 
> > I've made a "sister" demo of the time entry textbox - now for a date 
> > entry in the ISO yyyy-mm-dd format.
> > 
> > Again, a demo is included, ready to download and run:
> > 
> >     http://rdsrc.us/5xabOS
> > 
> > The error catching is somewhat different, but the inputmask plays a 
> > big role.
> > 
> > /gustav
> > 
> > ________________________________________
> > Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af 
> > Gustav Brock <gustav at cactus.dk> Sendt: 11. december 2015 14:07 Til:
> > Access Developers discussion and problem solving Emne: [AccessD] 
> > Entering 24-hour time with input mask and full validation
> > 
> > Hi all
> > 
> > Years ago - in Access 2.0 - I made a form with a bound textbox for 
> > 24-hour fool-proof input. Recently, I had this need again, so I 
> > brushed it up for A2013/2016 and wrote down the thoughts behind as a 
> > note on Experts-Exchange.
> > 
> > Here it is, including a demo ready to run:
> > 
> >     http://rdsrc.us/Le82yJ
> > 
> > It makes heavy use of an inputmask, the textbox's KeyPress event, 
> > and the form's Error event.
> > 
> > /gustav
> > 
> > --
> > 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



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