[AccessD] text control Date formats with SQL Server

Hi Steve

That is a nasty source of error because "mmm" is localized, thus this will fail for most non-English locales.
The ISO format is the only format which will never fail, that is why it is the native format for most SQL engines including MySQL, SAP, and SQL Server (since 2008 I think).

/gustav


>>> steve at goodhall.info 17-02-2012 18:44:58 >>>
I disagree.  I habitually use "dd-mmm-yy" or "dd-mmm-yyyy" (e,g, "17-Feb-12") which are unambiguous for both US and international readers.

Steve Goodhall, MSCS, PMP

-----Original message-----
From: David McAfee <davidmcafee at gmail.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Fri, Feb 17, 2012 17:39:15 GMT+00:00
Subject: Re: [AccessD] text control Date formats with SQL Server

I wish the whole world would adopt that standard. YYYMMDD is the best date
display IMO.