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

James Button jamesbutton at blueyonder.co.uk
Fri Jan 15 05:24:25 CST 2016


Agreed, 
Unless, there is a Kazakhstani enclave somewhere in the USA that cleaves to the
old ways.

Then us Europeans are amongst those who have learnt to accept that others have
their own ways - and determinedly resist education in the proper ways of things,
even to the extent of inventing their own ways rather than doing things the way
they should be done.

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Friday, January 15, 2016 11:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Entering an ISO date with input mask and full validation

Hi James

OK, missed that. Thanks.

So Kazakhstan may be the single place where this weird format is in use.
But that doesn't relate to the US.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af James
Button
Sendt: 15. januar 2016 12:03
Til: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Emne: Re: [AccessD] Entering an ISO date with input mask and full validation

Repost for those who missed my earlier post, and didn't find the WikiPedia link



That is one I have not come across - however there is (apparently) Kazakhstan
See https://en.wikipedia.org/wiki/Date_format_by_country

And, for those with input from countries that are not - by definition -
'Christian', there are other dating considerations because they will not be
working from the 'Birthday of Christ'
- Consider Thailand

Consequently - any dates in such countries should be accompanied with a
definition statement that dates are  'international format = 'yyyy/mm/dd' 
And for politeness - do not include the 'AD' or 'BC' bit associated with the
date.

Yes = almost all those making reasonably regular use of computer(s) will be
aware of the 'international' date - but ...
 That is not everybody - especially in the 'not- anglicised' countries.

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Friday, January 15, 2016 10:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Entering an ISO date with input mask and full validation

Hi all

Thank you for all the comments.
May I conclude that the reader is wrong when he states that the format
yyyy-dd-mm should be in use in the US?
In fact, according to WikiPedia, it isn't used anywhere, it doesn't even exist.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af James
Button
Sendt: 14. januar 2016 15:08
Til: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Emne: Re: [AccessD] Entering an ISO date with input mask and full validation

That is one I have not come across - however there is (apparently) Kazakhstan
See https://en.wikipedia.org/wiki/Date_format_by_country

And, for those with input from countries that are not - by definition -
'Christian', there are other dating considerations because they will not be
working from the 'Birthday of Christ'
- Consider Thailand

Consequently - any dates in such countries should be accompanied with a
definition statement that dates are  'international format = 'yyyy/mm/dd' 
And for politeness - do not include the 'AD' or 'BC' bit associated with the
date.

Yes = almost all those making reasonably regular use of computer(s) will be
aware of the 'international' date - but ...
 That is not everybody - especially in the 'not- anglicised' countries.

JimB
 


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

Like you say Gustav, it's the illogical mm/dd/yyyy here in the USA.  AFIK only
the Japanese have a sensible date format - yyyy-mm-dd - allowing for
chronological sorting of string date values.

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Thursday, January 14, 2016 4: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




More information about the AccessD mailing list