Date Entry Backwards

[SR]

I want date to be displayed and stored as Medium Date. I am using the Medium Date input mask and I have set format to Medium date. Date types in correctly but then when I press enter to move to next field, it is displayed and stored backwards (so that 16-jun-01 shows "01-jun-16". The strange thing is I did NOT I have this problem a month ago and wondering what I could possibly have done to frig this up. Very irked - can you possibly shed any light?

 

[jstutz]

Check your Regional Settings in the Control panel of your computer. Sounds like your Date format has gotten changed for your entire computer. Under Regional Settings is a tab called Date... that's where you can change it back.

js

 

[SR]

Thank-you thank-you thank-you. That was exactly it. Now I can haul my computer away from the window ledge....

 

[jstutz]

No prob!

 

[Pat Hartman]

FYI, Dates are stored using a strictly numeric format. The integer portion of the number represents the number of days since Dec 31, 1899 and the decimal portion represents time of day. Negative numbers represent dates prior to Dec 31, 1899. The value 0.0 is Midnight Dec 31,1899. 1.0 is Midnight Jan 1, 1900 and -1.0 is Midnight Dec 30, 1899.

The format you specify is ONLY used to control how a date is displayed.