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 >> >