[AccessD] text control Date formats with SQL Server

I wish the whole world would adopt that standard. YYYMMDD is the best date
display IMO.



On Fri, Feb 17, 2012 at 9:29 AM, Salakhetdinov Shamil <mcp2004 at mail.ru>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
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>