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

[Peter Hirons]

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