3139734 - How to report on Date Format only in Story reporting

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."

• SuccessFactors HXM Suite
• Report Center / Story Report

• Select a field such as "Start Date" from Employee Profile domain in Story Reporting
• Observe how the Date and time is returned

1. Create a Calculated Column
2. Select the function “TODATE” which converts a String in a specific format to a Date
3. Add the field in which you wish to change in the formula within the brackets e.g TODATE([Employee Profile#Previous Employment#Start Date])

1. Preview the Query again, observe that now you see Date value only

Story,report,time,date,format,remove,ToDate,Calculated,column,People,analytics , KBA , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , How To