[AccessD] text control Date formats with SQL Server

jwcolby jwcolby at colbyconsulting.com
Sat Feb 18 07:47:56 CST 2012


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

As do I.  However...

One of my favorite sayings is

"wish in one hand and spit in the other, and see which one fills up faster"


John W. Colby
Colby Consulting

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

On 2/17/2012 12:38 PM, David McAfee wrote:
> 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
>>



More information about the AccessD mailing list