Symptom
How to convert timestamp to date format in Story Reporting?
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 People Analytics
Resolution
- Create a Calculated Column
- Select the function “TODATE” which converts a String in a specific format to a Date
- Add the field in which you wish to change in the formula within the brackets e.g TODATE([Employee Profile#Previous Employment#Start Date])
- Preview the Query again, observe that now you see Date value only
See Also
Keywords
Story report date format, remove time from date, ToDate function, calculated column date, SAP SuccessFactors People Analytics, date only in report, format date field, convert string to date, date formatting in SAC, report center date issue, story report formatting, display date only, remove timestamp, date conversion, story report calculated field, date field not showing correctly, SAP Analytics Cloud date format , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , How To
Product
Attachments
image.png |
image.png |
image.png |
image.png |