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

  • SAP SuccessFactors People Analytics
  • SAP SuccessFactors HXM Suite
  • Report Center / Story Report

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


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

Attachments

image.png
image.png