Symptom
How to convert timestamp fields to Time format only on Story reports.
Environment
SAP SuccessFactors People Analytics
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;
- 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
SAP Knowledge Base Article - Public