[dba-SQLServer] Date format

It's not Access that's the problem, it's the SQL Server ODBC driver. 

It doesn't know about the new Date/Time data types and MS decided in their wisdom to pass 
those datatypes as Strings rather than as numerics.   You will get the same result with any 
programming environment which uses the same ODBC driver.

-- 
Stuart

On 20 Jun 2011 at 8:28, Robert Stewart wrote:

> Do not use Date type, use datetime type.  Access does not handle the
> date type correctly.
> 
> 
> At 07:32 PM 6/18/2011, you wrote:
> >Date: Sat, 18 Jun 2011 20:24:21 -0400
> >From: jwcolby <jwcolby at colbyconsulting.com>
> >To: Sqlserver-Dba <dba-sqlserver at databaseadvisors.com>
> >Subject: [dba-SQLServer] Date format
> >Message-ID: <4DFD41B5.8010703 at colbyconsulting.com>
> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> >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
> 
> Robert L. Stewart
> www.WeBeDb.com
> www.DBGUIDesign.com
> www.RLStewartPhotography.com 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>