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

[David McAfee]

My sister, ex-military,  always says "I'll arrive 9 January and depart 5
February"

Drives me nuts :)
On Jan 14, 2016 6:45 AM, "Susan Harkins" <ssharkins at gmail.com> wrote:

> 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
>