Symptom
The date formatting in Plateau Report Designer displays a 12 or 24 hour format depending on the case (Upper / Lower) the format code
Environment
- SAP SuccessFactors Learning Management System (LMS)
- Plateau Report Designer (PRD)
Reproducing the Issue
- Choosing format code MMM-DD-YYYY HH:mm:ss and 02/10/2016 12:00:01am
=> Expectation: the time format stays as 12 hour format
=> System behaviour: the display is 24 hour format
- Choosing format code MMM-DD-YYYY hh:mm:ss and 02/10/2016 00:00:01am
=> Expectation: the time format stays as 24 hour format
=> System behaviour: the display is 12 hour format
Cause
This is the expected behavior of the PRD
Resolution
- HH => 24hr format regardless of the time format you input in the DateTime preview
- hh => 12hr format regardless of the time format you input in the DateTime preview
Important Note: Customizing reports is handled by Professional Services. If further assistance is needed, please see KBA 2149831 on how to contact Professional Services.
Keywords
Plateau Report Designer, PRD, time format, date and time format SF SuccessFactors Learning LMS , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem
Product
SAP SuccessFactors Learning all versions