SAP Knowledge Base Article - Public

3403703 - How to report on time only (such as HH:MM:SS) in the Story report

Symptom

How to report on time format only in the Story report so instead of full time stamp (date and time) there will be only time

Environment

  • successfactor HCM 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

It is not possible to report on the time only.

This can't be achieved by function 'LEFT' as this function use String as input parameter.

This is expected behaviour as per current story report design.

It is only possible to report on date format (see KBA https://me.sap.com/notes/3139734)

See Also

https://me.sap.com/notes/3139734

https://me.sap.com/notes/3204317

Keywords

Timestamp, Time, string, number, LEFT, LEFT function, calculated, column, input, parameter, story, report, format, time format , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

Product

SAP SuccessFactors HXM Core 2311