[AccessD] text control Date formats with SQL Server

Gustav Brock gustav at cactus.dk
Fri Feb 17 17:48:02 CST 2012


Hi Stuart

Yep, some kind of dejavu here.
So John, please reveal the data type of your date field.

/gustav


>>> stuart at lexacorp.com.pg 17-02-12 23:32 >>>
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



More information about the AccessD mailing list