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.
Popular Podcasts
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
The Clay Travis and Buck Sexton Show
The Clay Travis and Buck Sexton Show. Clay Travis and Buck Sexton tackle the biggest stories in news, politics and current events with intelligence and humor. From the border crisis, to the madness of cancel culture and far-left missteps, Clay and Buck guide listeners through the latest headlines and hot topics with fun and entertaining conversations and opinions.