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
Attachments
Pasted image.png |