quirky date format behavior

[markjkubicki]

I have a date field on a form, and all I want it to do is look like this 03/08/2012 and have a date picker

instead what I get is: 08-Mar-12, which is ok
but as soon as I select the control, the format switches to: 201268.03.08,
and when I pick the date from the date picker, and loose focus on the control.. i get an error: "valuoe you entered isn't valid for his field"
yet when I correct 201268.03.08 to be 2012.03.08, it accepts the entry



dazed and confused; any suggestions will be greatly appreciated in advance,
mark

[June7]

Odd yes but must be a reason for the extra digits '68'. I haven't used the date picker (set input masks in my project). Does the field in table have Format property setting? Does the control have Format property setting? Do you want to provide project for analysis?

[markjkubicki]

it was odd: the user had a system date format set up as yyyy.mm.dd; when the '.' were changed to '-' (i.e. yyyy-mm-dd) the problem whent away

any thoughts on how I might deal with a user's quirky format in the future?

[June7]

The system date format caused issue? Never would have occurred to me. Sorry, no idea how to deal with except maybe an alert to the user when they install.