You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Incorrect Date Issue for Mac Users

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.

  • 48
  • 07-Jul-2019
  • 995 Views