SAP Knowledge Base Article - Public

2395468 - How to modify Date formatting in Integration Center?

Symptom

You wish to change date format in Integration Center so that it is reflected in the file generated at SFTP.

You would like to know the available date format for a field in Integration Center.

Environment

successfactors

Integration Center

Reproducing the Issue

NA

Cause

This is a custom requirement/preference in handling date time fields.

Resolution

From the "Field Configuration" tab, go to "More Field Options" as shown below:

2.png

You can find the available date formats and can change the format from the available options:

format options.png

 

Please, note the only available Time formats are the below ones:

yyyy-MM-dd

yyyyMMdd

yyyy-MM-dd'T'HH:mm:ss'Z'

yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

MM/dd/yy

MM/dd/yyyy

See Also

The availability of date formats vary with different fields.

This is only applicable for Date.Time fields and not to string fields.

For example:

lastModifiedWithTZ of User Entity is a String type field and you wouldn't find date formatting options.

Frequently asked questions (FAQ):

Q: Can I set a field in Integration Center which would have a UNIX timestamp as value?
A: No, this timeformat is not available on Field Option.

Keywords

Integration Center; Date time; timestamp; Time fields; SFTP; How to modify Date formatting in Integration Center? , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Core all versions