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

James Button jamesbutton at blueyonder.co.uk
Fri Jan 15 05:02:49 CST 2016


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