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 HXM Suite
- Integration
- Integration Center
- Integration
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 , ss_anonymizedkba , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To
SAP Knowledge Base Article - Public