[AccessD] Entering an ISO date with input mask and fullvalidation

[DJK (John) Robinson]

You don't say "the fourth of July"?

John


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 14 January 2016 14:45
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Entering an ISO date with input mask and fullvalidation


But how do we speak these days? In the US, we "say" January fifth, 2016. We don't say, 2016, January 5 or the fifth day
of January 2016. So, why would we write it any differently? Does any culture speak the year first? 

Why is the year first more easily understood? Only because someone likes it that way -- there's no inherent property
that makes it this way. 

Susan H. 

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