SAP Knowledge Base Article - Public

2283916 - Plateau Report Designer time formatting

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

  1. 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

    12hours.jpg
     
  2. 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

    24hours.jpg

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 , Plateau Report Designer , Problem

Product

SAP SuccessFactors Learning all versions