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