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

[Charlotte Foust]

That's interesting, Gustav.  My part of the US uses mm/dd/yyyy, and to my
knowledge that is the standard. Certainly it's the standard in SQL. System
settings control the default date format, and your user might not have been
aware of that fact.  The dates themselves are stored as numeric values, not
formatted dates anyhow.

Charlotte

Charlotte Foust
(916) 206-4336

On Thu, Jan 14, 2016 at 1:31 AM, Gustav Brock <gustav at cactus.dk> wrote:

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