SAP Knowledge Base Article - Public

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

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

  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

Keywords

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

Product

SAP SuccessFactors HXM Core 2111