[dba-SQLServer] Date format

That rings a bell, I discussed something similar recently on another forum, but I can't locate 
the details now.  It was something about ODBC returning a string in that format rather than a 
DateTime under some circumstances.   

I will keep looking, but in the meantime, can use use CVDate() to force it to a real date.

-- 
Stuart

On 18 Jun 2011 at 20:24, jwcolby wrote:

> 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
> _______________________________________________ dba-SQLServer mailing
> list dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>