SAP Knowledge Base Article - Public

2476697 - Date and time formatting in SAP SuccessFactors Learning Reports

Symptom

How do you control the date format in Learning reports?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors Learning
  • Plateau Report Designer

Reproducing the Issue

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

Cause

Date formatting is determined in one of 3 ways:

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

Resolution

  1. User's Date & Time Pattern

    • System (out of the box) Reports 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

dateTime_2.png

  1. 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.
    • Product Support is unable to assist with customization issues.

12hours.jpg

  1. 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. Logon to Learning Administration Side
  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

Note: A second entry may be created when you apply changes, this is OK and can be ignored

IMPORTANT: This setting follows the rules described HERE.

See Also

Keywords

prd, learning, report, standard, custom, time, date, pattern, output, value, definition, result, file, csv, last, update, tstmp, timestamp, stamp, LRN-10546, LRN-10637 , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors Learning all versions