Symptom
After running the User Connector - SF, the hire date shows dates to January or another incorrect date in the Learning UI.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
The configuration for accepting the hire date is set in the Learning admin side > System Administration > Configuration > System Configuration > CONNECTORS:
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=yyyy-mm-dd
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=yyyy-dd-mm
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=mm-dd-yyyy
Cause
This is caused by the syntax used in the above format, specifically the month values set as "mm".
Resolution
To correct it, it is recommended to engage the SAP team that delivers Professional Services or an SAP Certified Partner to review and perform adjustments in the connector configuration. Note that the month entry in the hire date line should be capital (MM). The reason being that the lower case (mm) is defining minutes and the uppercase is defining months.
E.g.: The correct line would be as follows:
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=yyyy-MM-dd
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=yyyy-dd-MM
- sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=MM-dd-yyyy
See Also
Verifying Hire Date Transformation for User Connector - SF
2404463 - SuccessFactors Learning Connector Workbooks FAQs
Engage Certified Partner to Import Data to SAP SuccessFactors Learning
Keywords
sfuser.field.transform.date.format.HIRE_DTE, date, user, connector, sf, wrong, different, configuration, incorrect, hire, date, format , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-USR , User Entity , Problem