Computer Learning Zone
Windows Two-Digit Year Cutoff: Why Dates Become 2040 and How to Change It
11:23
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…