Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
When we export Employee Card File information to excel, some dates are changing. For example - a D.O.B. might be 01/11/2000 (01 November 2000), however, it comes through to excel as 11/01/2000 (11 January 2000). Same thing occurs for Start Date. Really annoying to have to manually check each one off, and change as required. The specific report is Reports / Payroll / Employees / Employment Details.
I've checked our Computer settings and the Region & Language tab says Format = English (Australia), Location tab says Current location = Australia. We are in Perth, WA.
Would really appreciate a solution. Thanks.
When you send data to Excel, the formatting of the cells can be slightly changed, this is due to the way Excel does interpret the data.
If the data is not being formatting as you are after you can look at: