[AccessD] text control Date formats with SQL Server

I disagree.  I habitually use "dd-mmm-yy" or "dd-mmm-yyyy" (e,g, "17-Feb-12") which are unambiguous for both US and international readers.

Steve Goodhall, MSCS, PMP

-----Original message-----
From: David McAfee <davidmcafee at gmail.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Fri, Feb 17, 2012 17:39:15 GMT+00:00
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com