You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172
Home > General Info and Questions > Incorrect Date Issue for Mac Users
Incorrect Date Issue for Mac Users
print icon

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.

 

 

Feedback
0 out of 20 found this helpful

scroll to top icon