Birth Date Field

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

When my organization updated from Windows 98 to Windows
XP, our Access 97 Membership Files date of birth field
changed. Some members now have birthdays in the year
2000 something. This affected those born prior to 1935.
Any way to correct this?
 
Sounds like you were entering and storing two-digit years. I'm sure the
dates were always entered as 2000 something, you just never saw it because
you were only displaying a two-digit year. Birthdates should always be
entered with a four-digit year. A decade ago we still had a few folks born
before 1900 and now we have lots of kids born after 1999.

You either need to fix your data, or change your computer regional setting
short date format to show a two-digit year (like it used to), but this does
not fix the problem, it just hides it.

Rick B
 
A decade ago we still had a few folks born
before 1900 and now we have lots of kids born after 1999.
Click to expand...

There's a lady in my church named Lida Hall; she's 107 now. It's been
a few months since she attended but she's still living at home...
being cared for by her 85 year old daughter. One of her
great-great-great-granddaughters was born in '97 as she was.

John W. Vinson[MVP]
 
When my organization updated from Windows 98 to Windows
XP, our Access 97 Membership Files date of birth field
changed. Some members now have birthdays in the year
2000 something. This affected those born prior to 1935.
Any way to correct this?
Click to expand...

I had a similar problem when using the address wizard that came with Access
97. I entered the birth date of someone born in 1926, and Access kept changing
it to 2026.

I sent it to someone who was more of a fundi than me, and they found that the
form had a mask that would not permit the correct date to be entered.
 
It sounds to me that the Regional Settings in the old machines with Windows
98 were wrongly configured. IIRC, the default for Windows 98 as well as
Windows XP is to interpret 2-digit year as between 1930 and 2029. If you
have records that were entered previously under W98 OS and now show wrong
birthdates, they were interpreted incorrectly when the Records were created,
not because of Windows XP.

For new Records, you can change the default 2-digit year interpretation in
the Regional Settings. OTOH, birthdates should be entered using 4-digit
year as John Vinson pointed out.
 
Back
Top