Having trouble with setting default date format (XP vs Vista)

  • Thread starter Thread starter rocketeer
  • Start date Start date
R

rocketeer

I have a database that I copy between an XP computer and a Vista
computer. When I show records in XP, date/time fields display like
this: 12/02/2008. When I show records in Vista, they display like
this: 2008/12/02.

I've looked at my international settings on the Vista computer and it
is for the US. I looked throughout the Access setup and it doesn't
give me control over forwards/backwards.

What am I missing here?

Thanks,
Jerome.
 
Access gets its format from the operating system's Short Date format, which
is set through Regional Settings in the Control Panel. While you say that
your international settings on the Vista compure are "for the US", have you
confirmed the Short Date format?

For what it's worth, it doesn't matter. Format only affects how the data's
displayed, not how it's stored. Internally, dates are eight byte floating
point numbers, where the integer portion represents the date as the number
of days relative to 30 Dec, 1899 and the decimal portion represents the time
as a fraction of a day.
 
I found the bit in Control Panel that changes the system default from
yyyy/mm/dd. Now I'm happy with it. Thanks for pointing me that way.
Jerome.
 
Back
Top