Displaying dates correctly in Non-Transaction Data on a Windows 7 workstation

This support note applies to:

AE Reporter (NZ)
AE Reporter (AU)

Article ID: 33212

In MYOB Accountants Enterprise (AE) Reporter, on Windows 7 workstations when you enter dates in Non-Transaction Data fields you may experience the dates showing in US format.
To correctly show the dates in Australian format, set the short date format on the workstation to be D/MM/YYYY.
If you set the Short Date Format to be any other format, dates on the reports, such as in headings including column headings, may display incorrectly.

For example:
If you establish the Short Date Format as dddd, d MMMM yyyy, and then use the =YEAR function in a format the date displayed at preview is incorrect. This occurs even if you specify the Cell Format Category as Date/Time and the custom option of "yyyy". The cells using this unction display the full date for example Saturday, 1 July 2008 as it is using the Short Date Format from the Regional Settings on the workstation even though you format the cells to display the year only.

This is evident in the Column Headings throughout the MYOB Reporter Masters.

Similarly:
If you establish the Short Date Format as mm/dd/yyyy, and then specify a cell to use the Cell Format Category as Date/Time using the dd mmmm yyyy option, the date displayed at preview is incorrect. The cells using this setting display the date with the month showing first; for example 13/01/20xx displays correctly as 13 January 20xx but 12/01/20xx will display as 01 December 20xx.

This is evident on Page Headers and Cover Pages and Content Pages throughout the MYOB Reporter Masters.

To set the short date format

Follow the menu path: Start > Control Panel > Region and Language. The Region and Language window opens.
Click the drop-down list at the Short Date field and select D/MM/YYYY. The format is selected.
Click Apply and then click OK. The changes are saved and the window closes.