SAP Knowledge Base Article - Public

3491919 - Unable to change date format in Story reports

Symptom

Date format is fixed in a specific format and user is unable to change it in a Story report. I.e. Output of a Date format field is '25 Jul, 2024' and user wishes to change it to '25/07/2024'.

Environment

  • SAP SuccessFactors HCM Suite
  • SAP SuccessFactors People Analytics
 
 

Reproducing the Issue

Cause

This is an expected behavior as of the 1H2024 release where Story report date formats are now locale specific. This means that the date format in the output of Story reports will match the designated date format in the backend for that language. I.e. English (US) will display dates as '25 Jul, 2024', while German will display it as '25.07.2024'.

Resolution

A possible workaround for changing date formats is by creating a calculated column that rebuilds the dates based on extraction and reassembling the date. You may find the step-by-step of this workaround in KBA 2986093 - How to change the Date Format for a date field in Story report.

See Also

Locale-Specific Formats for Date, Time, and Numbers Are Now Supported in Stories

Keywords

Story, report, date, format, dd/mm/yyyy, transformation, extraction, time, locale. , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , How To

Product

SAP SuccessFactors HCM Core 2405