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