On my form day/month/year has switched

[Blue Karma]

On my form day/month/year has switched to year/month/day. On a table there are three separate date cells. Order Date, Shipping Date, and Report Date. They are each formated to medium style. At first I also used an input mask then I found that Access would convert to the format I choose. I had missed one of the input masks during the removal and when I removed the last input mask Access now converts to yy/mmm/dd. What just happened and how do I reverse this? It is more convienant for some of the users to not have the input mask but the order has to be uniform.

 

[gemma-the-husky]

you aren't changing or converting the date that held in the system, only the way its displayed.

 

[Blue Karma]

Yes, we need the display to be uniform so people can distinguish between day and year. We started out with one structure, dd-mmm-yy, with several records entered in this format, and now as new records are entered they are displaying yy-mmm-dd. How are users to tell the difference if it's not always the same?

 

[gemma-the-husky]

i presume your users "see" this data via a text box on a form, standardize the display format of the text box to one of the date formats, say short date, or long date, and you should have no problems

if you STILL have errors then perhaps your dates have actually been entered/stored incorrectly. If so, how do you get your data into the table