[AccessD] text control Date formats with SQL Server

Hi Steve

Yes, for display only it will work just fine.

/Gustav


>>> steve at goodhall.info 17-02-12 20:23 >>>
For internal storage I agree completely, but the original post referred to  
display.  I did a quick check on localization in Excel and it seems to work  
if the underlying data is a date.  I don't have the facility to try  
non-European languages on the client system or to try an Access application.  
 If I have time I will try it over the weekend.

Steve Goodhall, MSCS, PMP

-----Original message-----
From: Gustav Brock <Gustav at cactus.dk>
To: accessd at databaseadvisors.com
Sent: Fri, Feb 17, 2012 18:17:24 GMT+00:00
Subject: Re: [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.