If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Birth Date Field
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? |
#2
|
|||
|
|||
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 "Brenda" wrote in message ... 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? |
#3
|
|||
|
|||
On Mon, 20 Dec 2004 11:42:52 -0600, "Rick B" Anonymous wrote:
A decade ago we still had a few folks born before 1900 and now we have lots of kids born after 1999. 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] |
#4
|
|||
|
|||
On Mon, 20 Dec 2004 08:42:40 -0800, "Brenda"
wrote: 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? 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. -- Steve Hayes from Tshwane, South Africa http://www.geocities.com/Athens/7734/stevesig.htm E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk |
#5
|
|||
|
|||
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. -- HTH Van T. Dinh MVP (Access) "Brenda" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filtering on custom date field | MED | Contacts | 3 | September 17th, 2004 03:05 PM |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Pivot Table - Format of Date Field | Michelle | Worksheet Functions | 1 | February 3rd, 2004 07:56 PM |