3139734 - How to convert a timestamp into a date format in SAP SuccessFactors Story Reports

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.

SAP SuccessFactors HCM Suite

• Reporting (Ad Hoc, YouCalc, ORD)
  • Story Report
    • Query Designer - Filter, Calculated Column, Params 

1. Create a Calculated Column in Query Designer
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
   
   

Formula Functions in Calculated Columns for Story Reports

Story report date format, remove time from date, ToDate function, calculated column date, SAP SuccessFactors Story, 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-QDS , Query Designer - Filter, Calculated Column, Params , How To

SAP SuccessFactors HCM Core 2511 ; SAP SuccessFactors Platform 2511