SAP Knowledge Base Article - Public

3139734 - How to Convert Timestamp to Date Format in Story Reports?

Symptom

How to convert timestamp to date format 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

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

See Also

Formula Functions in Calculated Columns for Stories in People Analytics | SAP Help Portal

Keywords

Story report date format, remove time from date, ToDate function, calculated column date, SAP SuccessFactors People Analytics, date only in report, format date field, convert string to date, date formatting in SAC, report center date issue, story report formatting, display date only, remove timestamp, date conversion, story report calculated field, date field not showing correctly, SAP Analytics Cloud date format , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , How To

Product

SAP SuccessFactors HXM Core 2111

Attachments

image.png
image.png
image.png
image.png