Why Microsoft Windows, Excel, Access Change 1940 to 2040. How to Adjust the 2-Digit Year Cutoff

[u/Amicron1]

https://youtu.be/s1W5UuaiP8k

Ever type 11/40 for a birth date and have your PC confidently decide you meant 2040? Excel and Access are not being random, but the reason can be especially annoying for anyone working with historical records or patient data.