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?

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

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:

    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