Oct 18, 2023
2936
ISSUE
When importing with Transaction Pro Importer on a Mac computer, the dates import incorrectly.
RESOLUTION
Check to make sure that the 1904 date format is not turned on in Excel. If it is, it will cause dates to shift by 1462 days.
The Excel setting is in different places depending on the Office version. To read more about this setting and where to change it in Excel, reference this MICROSOFT ARTICLE.