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

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

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

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

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

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

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