Dataproofer icon indicating copy to clipboard operation
Dataproofer copied to clipboard

Test: check for dates in 1900 or 1904

Open newsroomdev opened this issue 9 years ago • 0 comments

Please read how to create a new test if you're interested in writing this test.

For reasons beyond obscure, Excel's default date from which it counts all other dates is January 1st, 1900, unless you're using Excel on a Mac, in which case it's January 1st, 1904. There are a variety of ways in which data in Excel can be entered or calculated incorrectly and end up as one of these two dates. If you spot them in your data, it's probably an issue.

-Quartz Bad Data Guide

newsroomdev avatar Jan 13 '16 17:01 newsroomdev