Is it possible to change the display format of a Date field in ORD or Report Canvas?
- SAP SuccessFactors HXM Suite
- Canvas report
Changing the date format in ORD is possible by using Calculated Columns.
- In the Calculated Column designer select the Date field to be modified
- Choose the Data Type Date and click on Edit Format
- 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, calculated column, mmddyyy, remove dashes from, fields, slash, minute, second , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To