3051949 - Comparing two datetime fields by date only in Integration Center

In Integration Center, you are comparing two datetime fields and want to consider only the date part of the field value for comparison.

"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 HCM suite

  • Integration Center

1. Create an Integration with CreatedOn datetime field and LastModifiedOn datetime field.

2. Add a calculated field and attempt to compare the CreatedOn and LastModifiedOn fields while considering only the date part and not the timestamp.

3. Observe that the results are not as expected. 

This is an expected Behavior.

Comparing the date time fields and while considering only date part in comparison is not possible.

Avoid using datetime fields to compare only the date part, as this is not supported. 

Use both the timestamp and date for comparison. 

Integration Center, datetime field, Date field, Comparing dates, timestamp, Calculation, Calculated field , KBA , ss_anonymizedkba , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem