SAP Knowledge Base Article - Public

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


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


  • successfactor HXM CORE
  • 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


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

See Also


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


SAP SuccessFactors HXM Core 2311