[AccessD] text control Date formats with SQL Server

jwcolby jwcolby at colbyconsulting.com
Fri Feb 17 13:17:48 CST 2012


It seems that it is a varchar field instead of date.  I am not sure why I did that.  I am also not 
sure why SQL Server stores the date (it is a date coming back from a date picker) in YYYY-MM-DD 
format into the varchar() field.

John W. Colby
Colby Consulting

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

On 2/17/2012 12:29 PM, Salakhetdinov Shamil 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
>>
>



More information about the AccessD mailing list