[AccessD] text control Date formats with SQL Server

The reason YYYYMMDD is preferable is that it sorts correctly.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 2/17/2012 12:44 PM, Steve Goodhall wrote:
> 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.
>
>
>
> On Fri, Feb 17, 2012 at 9:29 AM, Salakhetdinov Shamil<mcp2004 at mail.ru>wrote:
>
>> Hi John --
>>
>> Could it be that the source MS SQL Server field is an (N)(Var)Char one ?!
>>
>> -- Shamil
>>
>> 17 февраля 2012, 21:24 от jwcolby<jwcolby at colbyconsulting.com>:
>>> I am binding a form to a sql server table.  A date control is displaying
>> the date in YYYY-MM-DD
>>> format even though I have a mm/dd/yyyy as a format string.
>>>
>>> Any ideas why I am seeing this?
>>>
>>> --
>>> John W. Colby
>>> Colby Consulting
>>>
>>> Reality is what refuses to go away
>>> when you do not believe in it
>>>
>>> --
>>> 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
>>