SAP Knowledge Base Article - Public

2726015 - Changing Date Display Format in Online Report Designer or Report - Canvas

Symptom

Is it possible to change the display format of a Date field in ORD or Report Canvas?

Environment

  • SAP SuccessFactors HXM Suite 
  • Canvas report

Resolution

Changing the date format in ORD is possible by using Calculated Columns.

  1. In the Calculated Column designer select the Date field to be modified
  2. Choose the Data Type Date and click on Edit Format
  3. Select Use Custom Format and enter the desired format e.g. MMddyyyy. With this feature you can remove dashes "-" or slashes "/" that usually come with the displayed date value.

There is a Get Preview Values button which allows you to review the format before saving.

date format.JPG

Keywords

date format, calculated column, mmddyyy, remove dashes from, fields, slash, minute, second , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HXM Suite all versions