Symptom
How to Report on Date Format only 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
- SuccessFactors HXM Suite
- Report Center / Story Report
Reproducing the Issue
- Select a field such as "Start Date" from Employee Profile domain in Story Reporting
- Observe how the Date and time is returned
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
Keywords
Story,report,time,date,format,remove,ToDate,Calculated,column,People,analytics , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , How To
Product
SAP SuccessFactors HXM Core 2111