2476697 - Date and Time Formatting in LMS Reports

SAP Knowledge Base Article - Public

2476697 - Date and Time Formatting in LMS Reports

Symptom

How do you control the date format in LMS Reports?

Environment

  • SAP SuccessFactors Learning Management System (LMS)
  • Plateau Report Designer (PRD)

Reproducing the Issue

  1. Run a System or Custom Learning Report that returns results in a CSV
  2. Note the formatting of the date
  3. How is that format determined?

Cause

Date formatting is determined in one of 3 ways:

  • The locale Date & Time Pattern settings of the user who ran the report
  • The Date/Time Format set in the Plateau Report Designer
  • Date/Time Format set in the REPORT_SYSTEM configuration file

Resolution

User's Date & Time Pattern:

System (out of the box) Reports are set to use the User's locale for the date formatting.  This is set in the User's preferences

  1. Click the cogwheel for preferences
  2. Under Settings > Update the Locale Format Options, set Date Pattern ID and Time Pattern ID
  3. See KBA 2175518 for more information on setting Date & Time format for Users & Admins
    1. dateTime.png

Date/Time Format in the Plateau Report Designer

  • Please see KBA 2283916 for details on formatting the date/time in the PRD
  • Note that customizing reports is handled by Professional Services.  Customer Support is unable to assist with customization issues.
    • 12hours.jpg

Date/Time Format in REPORT_SYSTEM Configuration

If a custom report does not have date formatting specified at the PRD level, the User's locale may not be picked up and an extra comma is displayed or some other expected formatting.  The REPORT_SYSTEM configuration file should be updated as follows:

  1. Login to LMS Admin
  2. Navigate to System Admin > Configuration > System Configuration
  3. Open REPORT_SYSTEM in edit mode
  4. Find the entry for defaultDateTimeFormats
  5. There will be a default entry:
    • defaultDateTimeFormats.<localeid>=<format>
  6. Overwrite:
    1. defaultDateTimeFormats.<localeid>=<format>
  7. With (example USA format):
    1. defaultDateTimeFormats.en=MMM dd, yyyy hh:mm a
  8. Apply Changes
  9. Note: A second entry may be created when you apply changes, this is OK and can be ignored
    1. RS.png

Important Note: This setting follows the rules described here:

http://icu-project.org/apiref/icu4j/com/ibm/icu/text/SimpleDateFormat.html

Keywords

SF SuccessFactors Learning Management System LMS Report date time datetime format pattern extra comma output csv results last update tstmp timestamp stamp LRN-10546, LRN-10637 , KBA , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions