SAP Knowledge Base Article - Public

2690971 - Hire Date on Connector is giving unexpected results for date on UI

Symptom

After running the Connector, HIRE_DTE is populating dates to January or another incorrect date

Environment

SAP SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

Configuration for accepting in the Hire Date is set in the connector Configuration File

  • 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

However after you run it the dates are not correct and seem to be set to January or similar

Cause

This is caused by the syntax used in the above format, specifically the Month values of mm

Resolution

To Resolve this issue, update the configuration, setting the mm to capital MM.

The reason being that the lower case mm is defining minutes and the uppercase is defining Months

The correct method is as follows -

  • sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss=yyyy-MM-dd

Depending on the way the dates are set up on the incoming file, you may change it around i.e. dd-MM-yyy but the key is to use capital MM for the month

Keywords

sfuser.field.transform.date.format.HIRE_DTE.MMM-dd-yyyy\ HH\:mm\:ss, HIRE_DTE, sfuser.field.transform.date.format , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions