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

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

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:

<Please see attached file for image>

<Please see attached file for image>

Fig.2 Detail Report

Solution:

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.

Environment

Release:
Component: ARGIS