SAP Knowledge Base Article - Public

2978822 - Calculated Field to compare dates - Integration Center

Symptom

You want to build a calculated field to compare 2 dates and set one of them as the final value by following the logic below:

If start date <= xx/xx/xxxx

Then field = xx/xx/xxxx

Else

Field = start date

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 Center

Resolution

I used as an example the date: 01 Feb 2020.

The logic to create this calculated field is represented in the image below:

All dateTime Fields must be set as the following template, you can configure it by clicking on the right button of the Field Value > More Field Options. :

When selecting the startDate field, be sure that the parameter <LAST> is configured in both navigation/field. 

The expected CSV file will be exported as the image below:

See Also

Integration Center guide: https://help.sap.com/doc/0c0be9005af14c4f89b986a677bf270f/latest/en-US/SF_Integration_Center.pdf

Keywords

Calculated Field, Integration Center, DateTime, Outbound integration, Comparison  , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM suite all versions

Attachments

Pasted image.png