SAP Knowledge Base Article - Public

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

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


  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])

  4. 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 , Stories in People Analytics , How To


SAP SuccessFactors HXM Core 2111