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

Gustav Brock gustav at cactus.dk
Thu Jan 14 08:08:35 CST 2016


Hi Charlotte

So do you know of any part of the US not using the mm/dd/yyyy format?
Is this reader just way off - on some outpost in Alaska or the Atlantic Ocean?

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Charlotte Foust
Sendt: 14. januar 2016 14:52
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'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 



More information about the AccessD mailing list