change the Date Format on a Service Desk Summary/Detail Report?

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

By default, in the Summary/Detail Report generated from the 'Reports' -> 'Summary' or 'Detail' menu option in the Service Desk web interface, the date format is MM/DD/YYYY.

The date format in the report is not controlled by the DateFormat parameter in the web.cfg file as the other dates in the web interface are.

See below:

Environment

CA Service Desk Manager 17.1 and higher.

Resolution

In order to change the date format in the Summary/Detail Report, you need to edit the file $NX_ROOT\fig\cfg\dataent.fmt and make the following changes:

1. Locate the following sections:
   
   default_date = "long_date"
   short_date = "M/D/YY// Enter a date as MM/DD/YY"
   long_date = "MM/DD/YYYY// Enter a date as MM/DD/YY"
   
   and
   
   default_date_time = "date_time12"
   date_time12 = "M/DD/YYYY h:mm:ss a(am,pm)// Enter a date and time as MM/DD/YY hh:mm:ss am/pm"
   date_time24 = "M/DD/YYYY HH:mm:ss// Enter a date and time as MM/DD/YY 00:00:00-23:59:59"
   
   
2. Change "M/DD/YYYY" to "DD/M/YYYY" and change "MM/DD/YYYY" to "DD/MM/YYYY" in the above sections and then save the file.
   
   
3. Recycle Service Desk service for the changes to become effective.