Use simple data formats

This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the data category.

Last Updated: 2021-05-15

In the Project M project, we were given PayPal data in the Excel format.

This tripped up my downstream tools. What's more, my import tools assumed the wrong timezone (i.e. UTC instead of the my computer's one or the one in the import data).

The specific issue is that Excel stores dates and time as days since 1 Jan 1900 (and as something else again on the Mac version of Excel).

Lesson: