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:
Integration Center guide: https://help.sap.com/doc/0c0be9005af14c4f89b986a677bf270f/latest/en-US/SF_Integration_Center.pdf
Calculated Field, Integration Center, DateTime, Outbound integration, Comparison , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To