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?

book

Article ID: 18702

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:

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

Attachments

1558717675590000018702_sktwi1f5rjvs16uo9.gif get_app