SAP Knowledge Base Article - Public

2978822 - Calculated Field to compare dates - Integration Center


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


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.


SAP SuccessFactors HXM Suite

  • Integration Center


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:


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


SAP SuccessFactors HCM suite all versions


Pasted image.png