jwcolby
jwcolby at colbyconsulting.com
Sat Jun 18 19:24:21 CDT 2011
I have a table where a field is a date type. For some reason the date is stored (or at least displayed) in YYYY-MM-DD format. In my Access FE I am trying to use the date picker from http://allenbrowne.com/ser-51.html All the other dates in the system work well with this control (form) but not this one specific date. The format string placed in the access control does not modify it to be the more (American) normal mm/dd/yyyy. Does anyone have any ideas why sql server would store / display it in this format? If I reformat it on the way out to my form, can I store it back in in the more "normal" format and have it store? -- John W. Colby www.ColbyConsulting.com