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

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

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:

Figure 1

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.