Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · July 22 · 11 min

Windows Two-Digit Year Cutoff: Why Dates Become 2040 and How to Change It

Why does entering a date like 11/40 in Excel or Microsoft Access turn into 2040 instead of 1940? The answer is Windows' two-digit year cutoff, a system setting that decides which century a two-digit year belongs to. This episode explains why the cutoff exists, why Excel and Access can interpret dates the same way, and why the default behavior may be a problem for medical offices, genealogy work, museums, cemetery records, and other historical data entry. Learn when changing the Windows cutoff may make sense, why relying on two-digit years can create inconsistent data between computers, and why entering a full four-digit year in ISO format is still the safest habit.

0:00-11:23
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Why does entering a date like 11/40 in Excel or Microsoft Access turn into 2040 instead of 1940? The answer is Windows' two-digit year cutoff, a system setting that decides which century a two-digit year belongs to.

This episode explains why the cutoff exists, why Excel and Access can interpret dates the same way, and why the default behavior may be a problem for medical offices, genealogy work, museums, cemetery records, and other historical data entry.

Learn when changing the Windows cutoff may make sense, why relying on two-digit years can create inconsistent data between computers, and why entering a full four-digit year in ISO format is still the safest habit.

more episodes

All episodes