SAP Knowledge Base Article - Public

2690971 - Hire date passed over the User Connector - SF gives an unexpected result in the UI

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

2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud]

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

Product

SAP SuccessFactors Learning all versions