SAP Knowledge Base Article - Public

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

Symptom

How to convert timestamp fields to Time format only on Story reports.

Environment

SAP SuccessFactors People Analytics

Reproducing the Issue

  1. Select a field such as "Start Date" from Employee Profile domain in Story Reporting;
  2. Observe how the Date and time is returned;
  3. There is no option to show only time related info.

Cause

Expected behavior from the system. This is how the application was designed, and currently there is no workaround available to change it. 

Resolution

It is not possible to report on the time information only.

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

This is expected behavior as per current Story application design.

It is only possible to report on date format, for more information regarding this, you can refer to KBA 3139734 - How to Convert Timestamp to Date Format in Story Reports?.

See Also

Keywords

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

Product

SAP SuccessFactors HXM Core 2311