Incorredt date when exporting to Excel

Question

The Exporting to Excel feature in MYOB is converting the date from AUD format (dd/mm/yyyy) to USD format (mm/dd/yyyy) as per the details in the attached document.

The attached document has both the General Ledger Detail in the PDF & Excel versions. The PDF version is reporting the date correctly but when it is being exported to Excel it is mixing the day and month.

The detials were uploaded via a journal.

The Windoows setting show Melbourne Sydney Time Zone.

How do I fix this so that the Excel version prints the date correclty?

mike_james · Answer

Hi MichaelSpall&nbsp;, I notice that the date format on the journals is dd-Mmm-yy, and I wonder whether setting the short date format to dd/MM/yyyy may work better.&nbsp;When you change the short date format, also select the Adminstrative tab, and tick the option to copy the settings to system accounts.&nbsp;

michaelspall · Answer

Hi Mike,&nbsp;Thanks for the reply, though I'm not sure where I need to go to change the date information, in MYOB or Windows?&nbsp;&nbsp;Thanks&nbsp;Michael

mike_james · Answer

Hi MichaelSpall&nbsp;, that's a Windows setting, via the control panel, regional/language settings, or search for date time settings. I'm not in my office now.

Forum Discussion

Incorredt date when exporting to Excel

3 Replies

Looking for something else?

Related content

Can't export reports to Excel

Exporting reports to excel

Unable to Export Reports to Excel

AccountRight not exporting to Excel

To export the Excel out put

Export Reports to Excel

Exporting to Excel

Error when Exporting to Excel