CSV format reports generated via 'Scheduled Reports' shows incorrect date format.

Document ID : KB000005094
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

CSV format reports generated via 'Scheduled Reports' shows incorrect date format.

The scheduled reports from DSM reporter that save to a CSV file output are in the US date format MM/DD/YYYY.

If I manually export the same report from DSM Explorer the Date format is in the correct format DD/MM/YYYY.

We follow the DD/MM/YYYY format and want this date format to be displayed in the report.

 

Environment:
Client Automation version - 12.8, 12.9, 14.0, 14.0 SP1
Resolution:

The reports are dependent on the system timezone and regional settings.

For the report to be able to display the desired date format (in this case DD/MM/YYYY - English Australia) change the 'Regional and Language Options' to the desired format under Control Panel as per the screenshots below:

1. Under the 'Formats' tab change the current format to 'English (Australia)'

1.png

 

2. Under the 'Location' tab change current location to 'Australia'

2.png

 

3. Under the 'Administrative' tab click on 'Change system locale' and change the current system locale to 'English - Australia'.

Note: You will be prompted to reboot the machine to save the changes.

3.png

4.png

 

4. Under the 'Administrative' tab click on the 'Copy to reserved accounts' option. Enable both the options 'Default user account (new users)' and 'System accounts'. Click OK.

Note: This is the key setting for the exported CSV report to show the correct date format. A reboot is not required.

5.png

6.png