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

book

Article ID: 49646

calendar_today

Updated On:

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>

Figure 1

<Please see attached file for image>

Figure 2

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

Attachments

1558709851602000049646_sktwi1f5rjvs16ro3.gif get_app
1558709849793000049646_sktwi1f5rjvs16ro2.gif get_app