How to change the date format from mm-dd-yyyy to dd-mm-yyyy in the CA Business Intelligence (CABI)'s Web Intelligence (WEBI) reports?

Article Id: 18702
Status: Published
Updated On: 14-02-2018 06:50
Legacy Id: TEC609086
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:

How to change the date format from mm-dd-yyyy to dd-mm-yyyy in the CABI WEBI reports?

Solution:

To change the date format from mm-dd-yyyy to dd-mm-yyyy in the CABI WEBI reports, for example, on Close Date field, perform the following steps:

  • Login to the CABI Designer with the Administrator credentials.

  • Click on File and then Import to import the derived universe.

  • Right click on 'Close Date' field and click on Object Format.

  • Select Date/Time in the Number tab and select the required date format dd/mm/yyyy as show in the below screenshot:

    <Please see attached file for image>

    Figure 1

  • Click on Ok.

  • Save the universe by : File -> Save

  • Click on File and then Export to export the Universe back to the CABI server.

Retry the reports

Environment:

Release:
Component: ARGIS

insert_drive_file 1558717675590000018702_sktwi1f5rjvs16uo9.gif
arrow_downward Download