SAP Knowledge Base Article - Public

2797087 - Integration Center Date Field : How to convert to UK Format (dd/MM/yyyy , dd/mm/yyyy, dd-MM-yyyy)

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.

date.jpg

Note : It will NOT work if you enter 'MM' in lower case ('mm')

See Also

SAP Successfactors Integration Center Guide

How to modify Date formatting in Integration Center?

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

Product

SAP SuccessFactors HCM Core all versions