3632953 - integration Center Calculated Filter field value not working as expected when we use Date Comparison

Integration Center Calculated Filter field value calculation is not working when we set "Field Value=<Now>" and we compare this date with a Date field.

You are getting the records in the Preview section but when you actually run the IC job the record is not included. The logs show "No of Records Processed in this batch - 0" even though when we check in the Calculation Trace of Calculated filter the record condition is set as true and we can see the record in the Preview

Disclaimer: 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
  
  • Integrations
    • Integration Center

1. Go to Integration center
   
   
2. Create a new integration, select the starting entity and required fields as per your requirement
   
   
3. Go to "Filter and Sort" and Click on Calculated Filter
   
   
   
   
4. Create a Calculation as shown in the Screenshot 
   
   
   
   
5. Where you Select the Data Type as DateTime and add the fieldvalue as <NOW> for the Field Value
   
   
   
   
6. When you check the Configure Fields, you will see the Preview Records, but when they actually run the IC job the record is not included and Execution logs show "No of Records Processed in this batch - 0" even though you can see the record in the Preview.

By default, FieldValue - <Now> is treated as a string, which results in a string comparison rather than a date-time comparison.

To resolve the issue you will have to Use <TODAY> instead of <Now> , as it will compare the Date at runtime it will execute the Integration Center Job as expected.

Please Note: In preview output may differ since it consider browser timezone and not Tenant Timezone.

2729338 - Integration Center: How to Filter on Custom & Non-Filterable Fields

integration center, LOD-SF-INT-INC-FWK, Calculated Filter, Date Comparison, Now, Today, No of Records Processed in this batch - 0 , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-JOB , Integration Center Job , Problem

SAP SuccessFactors HCM Core 2505 ; SAP SuccessFactors HCM Suite 2505