Symptom
- In a place where the calendar date picker is used, once the month of September is selected as part of the desired date, it appears with an extra letter (Ex.: “Sept”).
- When running a custom report, the September month is displayed as "Sept" on the date fields.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Learning Activities > Classes > Add New > "Start Date" field > Select the desired from September > The system displays "Sept" >
- Learning Activities > Items > Access the desired item > "Actions" tab > Schedule > "Start Date" field > Select the desired from September > The system displays "Sept".
- Reports> Select a custom report> Add a filter> Run the report> September month on date fields are displayed as "Sept".
Other scenarios might present the same outcome.
Resolution
This is an expected behavior.
“Sept” is the valid short month name for English Australia and English UK locales as per the Common Locale Data Repository (CLDR) specification. The CLDR library has made these changes to match the standard abbreviations.
The Learning UI is based on the CLDR standards, and the system is being transitioned from legacy date format standards to CLDR.
For custom reports, this will occur when the customized report has <structure name="dateTimeFormat"> for date result column with <property name="pattern">dd-MMM-yyyy</property>.
When dateTimeformat property is used, it is necessary to provide the eventHandlerClass with FORMAT_TYPE as String along the dateTimeFormat to generate the report for admin locale English_uk as Sep instead of Sept. When it is not specified, birt report engine uses java17 date formatters and generate the month as Sept for english_uk.
A solution would be to add the proper eventHandlerClass (PlateauDataItemEventHandler) and format type properties to the custom report.
As an example, see below code snippet added to the "UserCurriculumItemStatusCSV" report property file:
<cell id="1859">
<data id="1895">
<property name="eventHandlerClass">com.plateau.common.reportservice.impl.PlateauDataItemEventHandler</property>
<property name="newHandlerOnEachEvent">true</property>
<list-property name="userProperties">
<structure>
<property name="name">FORMAT_TYPE</property>
<property name="type">string</property>
<property name="isVisible">true</property>
</structure>
</list-property>
<property name="FORMAT_TYPE">DateTime</property>
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">dd-MMM-yyyy</property>
</structure>
<property name="resultSetColumn">COMPLETION_DATE</property>
</data>
</cell>
To perform the customization in the report, we recommend you reach out to your CSP to assist in engaging the SAP Professional Services team to analyze it and verify the request since it goes beyond SAP Support area of scope and expertise. For further information about Custom Report Development and Support - SAP SuccessFactors Learning please check the KBA 2379690.
In case modifying the custom report is not an option, then you can simply change the admin locale to "English" instead of "English United Kingdom" under Learning Administration> Preferences for the admin running the report.
See Also
Keywords
calendar, month, format, sept, september, wrong, differ, locale, language, learning, user, admin, bizx, different, match, uk, united, kingdom, australia, sep, date, custom, report, reporting, customization, prd , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-INT , Integrations with BizX , Problem