Incorredt date when exporting to Excel

[MichaelSpall]

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]

Hi @MichaelSpall , 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.

When you change the short date format, also select the Adminstrative tab, and tick the option to copy the settings to system accounts. 

[MichaelSpall]

Hi Mike,

Thanks for the reply, though I'm not sure where I need to go to change the date information, in MYOB or Windows? 

Thanks

Michael

[Mike_James]

Hi @MichaelSpall , 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.