Dates Exported from Connected Reports to Excel Don't Match

Modified on Tue, 29 Oct 2019 at 02:04 PM

This article covers changing the data formats in macOS and Windows 10.

How to change Date formats in macOS


In some cases, when sending a report from the Connected Accounting and ERP Software to spreadsheet (Microsoft Excel) the dates won't match. When this happens, it is because Excel is interpreting the date in a different format other than the MM/DD/YY, which is used by Connected.  Excel uses the date format specified in your computer System settings, which often will default to a DD/MM/YY format for some Canadian or European based computers.


To resolve this issue, change the system date settings on your computer.  The following example is how to change the setting in mac.


1) Select System Preferences from the Apple menu.

2) Click the Language & Region option, as shown in the following screen:



 

3) In the Language & Region screen, click the "Advanced" button.




4) Make the changes to the date settings to use the MM/DD/YY format, as shown in the following screen.




How to change date and time formats on Windows 10


1) Open Settings.
2) Click on Time & language.
3) Click on "Change Date and time formats" as shown below:


4) Under format click the Change date and time formats link.
5) Use the Short name drop-down menu to select the date format you want to see in the Taskbar. (MM/DD/YYYY) is the format you want here



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article