Symptom
Is it possible to change the display format of a Date field in Canvas Report?
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
Cause
Resolution
Changing the date format in Canvas Report 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.
Legend:
yyyy = Year (*not YYYY)
MM = Month (numeric)
MMM = Month (text abrv)
mm = time, minute
There is a Get Preview Values button which allows you to review the format before saving.
Note: It is not possible to change the time zone change within this functionality. It will continue from the user running the report.
See Also
Keywords
date format, calculated column, mmddyyy, remove dashes from, fields, slash, minute, second, Canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To