Year 1900 problem

The year 1900 problem concerns the misinterpretation of years recorded by only their last two digits, and whether they occurred before or after the year 1900. Unlike the year 2000 problem, it is not tied to computer software alone, since the problem existed before electronic computers did and has also cropped up in manual systems.

The most common issue raised by the year 1900 problem regards people's ages. Often, a person's birth year was registered with only two digits, on the assumption that either it was not important exactly how old a person is, or that no one lives longer than one hundred years. In several countries, especially in Europe, a national identification number was introduced (often in the 1950s), including two-digit information about the birth year.

The largest unwelcome side effect from this is people 100 or more years old being mistaken for young children or in some cases, young children being mistaken for adults.[1]

When handling the year 2000 problem, measures were sometimes taken to avoid or rectify this: modifying the national identification number, for instance. For example, the year is recorded only with two digits in the Bulgarian Uniform civil number; however, a solution was ready as early as the inception of the system in 1975: 20 was added to the month number for an individual born before 1900 and 40 for those born in or after 2000.

Microsoft Excel

Microsoft Excel (using the default 1900 Date System) cannot display dates before the year 1900, although this is not due to a two-digit integer being used to represent the year: Excel uses a floating-point number to store dates and times. The number 1.0 represents the first second of January 1, 1900, in the 1900 Date System (or January 2, 1904, in the 1904 Date System – the default for Macintosh prior to Excel 2016). Numbers smaller than 0.0 display as a #VALUE! error.[2]

For compatibility with Lotus 1-2-3, the 1900 Date System incorrectly accepts the date February 29, 1900, even though 1900 was not a leap year. This also has the side effect that the WEEKDAY function reports incorrect values for the period Jan 01 1900 to Feb 28 1900.[3]

See also

References

  1. ^ "5-Year-Old Boy Summoned For Jury Duty". WBAL-TV. March 8, 2006. Archived from the original on September 30, 2011. Retrieved March 31, 2017.
  2. ^ "Date systems in Excel". support.microsoft.com. Retrieved November 17, 2025.
  3. ^ "Excel incorrectly assumes that the year 1900 is a leap year". Microsoft Docs. May 21, 2020. Retrieved July 30, 2020.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.