Symptom
How to convert Integration Center Date Fields from standard selection (US date formats) to UK date format (dd/MM/yyyy , dd/mm/yyyy, dd-MM-yyyy)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Successfactors HCM Suite
Reproducing the Issue
Under More field option the available list of date format are as follows
- yyyy-MM-dd
- yyyyMMdd
- yyyy-MM-dd'T'HH:mm:ss'Z'
- yyyy-MM-dd'T'HH:mm:SSS'Z'
- MM/dd/yyyy
- MM/dd/yyyy
Cause
Expected behavior
Resolution
Under 'More Field Option(s)' (On Configure Fields Tab > right click on the date field > Select More Field Options)
Enter dd/MM/yyyy or dd-MM-yyyy UK date format and the date field values are automatically converts the date format.
e.g.
Note : It will NOT work if you enter 'MM' in lower case ('mm')
See Also
Keywords
UK Date format, dd/MM/yyyy, date formatting, integration center, US date format, More Field Option , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To