[AccessD] text control Date formats with SQL Server

I seem to remember explaining the same thing to the same enquirer a while ago, complete 
with reference to a MS page describing why it returned a string instwead of a date value :)

-- 
Stuart

On 17 Feb 2012 at 18:46, Gustav Brock wrote:

> Hi John
> 
> Sounds like are linking to a field of data type DateTime2 which Access doesn't understand, thus it is casted to a string.
> Change the field to data type DateTime.
> 
> /gustav
> 
> 
> >>> jwcolby at colbyconsulting.com 17-02-2012 18:22:00 >>>
> 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
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>