Forum Discussion

MichaelSpall's avatar
MichaelSpall
Contributing User
2 years ago

Incorredt date when exporting to Excel

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?

3 Replies

Sort By
Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    2 years ago

    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's avatar
      MichaelSpall
      Contributing User
      2 years ago

      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's avatar
        Mike_James
        Ultimate Partner
        2 years ago

        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.