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

[Stuart McLachlan]

If you have to specify the era,  AD and BC  have been replaced( in politically correct speak) 
with CE (Common Era) and BCE (Before Common Era)  

-- 
Stuart


On 14 Jan 2016 at 14:07, James Button wrote:

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