Date formating is diferent on every PC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 pc's looking at the same database stored on a server PC. 2 run win98
and 1 runs xp pro. I have set the table field to short date and the form
fields to short date but when you open a form the xp PC shows 01/08/2006 and
1 98 pc shows 01/08/06 and the other 98 pc shows 08/01/06.Is there a pc
setting or access setting that I am missing. Please help.
 
jimg3 said:
I have 3 pc's looking at the same database stored on a server PC. 2
run win98 and 1 runs xp pro. I have set the table field to short date
and the form fields to short date but when you open a form the xp PC
shows 01/08/2006 and 1 98 pc shows 01/08/06 and the other 98 pc shows
08/01/06.Is there a pc setting or access setting that I am missing.
Please help.
Click to expand...

The named formats (short, long, medium) honor the regional settings on each PC.
If you want a consistent format across PCs then don't use the named formats.
Use explicit format strings like "mm-dd-yyyy".
 
Back
Top