[dba-SQLServer] Date format

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