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?

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
• CA Service Desk Manager
• 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>

  
  
  
• 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