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 Workforce Analytics

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, date display in ORD, calculated column date format, mmddyyy, remove dashes from date fields, remove slash from date fields, canvas reports dates , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1808