View Full Version : 1 mde form shows 2 diff date formats for users


arage
09-20-2001, 12:18 PM
1 mde form shows 2 diff date formats for users
My .mde front end improperly formats a date from mm/dd/yy formate to dd/mm/yy format for one of my users. They’re pulling the .mde off the suerver which is slow I know, but when I try to see the problems using the same file, the formatting is fine, nothing is affected or changed. My user says tabbing out of the field causes the problem but when I fix her mistake and tab out of the field, the field does not revert to the incorrect format it stays correct. The backend is storing these dates in the format that appears on the screen as well. And what’s also funny is my user says february and july are NOT problem months, but something like august is. What’s going on?

arickards
09-20-2001, 01:35 PM
It's possible their local PC system date time format is causing this. Check the Control Panel and Regional settings.

HTH

arage
09-20-2001, 01:44 PM
this users short date format is dd/mm/yy under the regional settings date tab, would that be causing it? should i request a change to mm/dd/yy?