SAP CPI-Filter condition for date for SF integration

[Pooja0007]

Hi all,

I have a requirement to filter record where Start date is greater than current date . means only record with Start date less than today''s date should go further.

I have tried to use details in this solution but its not working:

https://community.sap.com/t5/technology-q-a/sap-cpi-filter-condition-to-compare-with-date/qaq-p/1215...

filter to be applied on:
queryCompoundEmployeeResponse/CompoundEmployee/person/personal_information/start_date
kindly suggest what to do.I have tried xslt, groovy and custome query to add startdate but payment infomation doesnot come with STARTDATE in query.
Please find attached XML from SuccessFactors where record is pulled based on "last modified on" and need to 1 more condition on START date.


---- sample data---
<?xml version='1.0' encoding='UTF-8'?>
<queryCompoundEmployeeResponse>
<CompoundEmployee>
<id>1234</id>
<person>
<country_of_birth>US</country_of_birth>
<created_by>00606107</created_by>
<created_on_timestamp>2024-02-23T12:21:59.000Z</created_on_timestamp>
<date_of_birth>1983-10-28</date_of_birth>
<last_modified_by>00606107</last_modified_by>
<last_modified_on>2024-02-23T12:21:59.000Z</last_modified_on>
<logon_user_id>00708160</logon_user_id>
<logon_user_is_active>false</logon_user_is_active>
<logon_user_name>B0708160</logon_user_name>
<per_person_uuid>92A7FF006E18ndasbdn</per_person_uuid>
<person_id>9823</person_id>
<person_id_external>00708160</person_id_external>
<place_of_birth>abc</place_of_birth>
<personal_information>
<created_by>00606107</created_by>
<created_on_timestamp>2024-02-23T12:22:16.000Z</created_on_timestamp>
<custom_string2>01</custom_string2>
<end_date>9999-12-31</end_date>
<first_name>abcd</first_name>
<formal_name>abcd</formal_name>
<gender>M</gender>
<is_overridden>true</is_overridden>
<last_modified_by>00606107</last_modified_by>
<last_modified_on>2024-02-27T05:43:30.000Z</last_modified_on>
<last_name>ab</last_name>
<marital_status>M</marital_status>
<nationality>US</nationality>
<native_preferred_lang>es</native_preferred_lang>
<preferred_name>abcd</preferred_name>
<second_last_name>Silva</second_last_name>
<start_date>2024-03-28</start_date>
</personal_information>
<personal_information>
<created_by>IDSSMIG</created_by>
<created_on_timestamp>2022-10-26T05:56:36.000Z</created_on_timestamp>
<custom_string2>01</custom_string2>
<end_date>2024-02-27</end_date>
<first_name>Carlos Alfonso</first_name>
<formal_name>Carlos Alfonso Alvarez</formal_name>
<gender>M</gender>
<is_overridden>false</is_overridden>
<last_modified_by>IDSSMIG</last_modified_by>
<last_modified_on>2023-05-17T08:29:33.000Z</last_modified_on>
<last_name>Alvarez</last_name>
<marital_status>M</marital_status>
<nationality>MEX</nationality>
<native_preferred_lang>es</native_preferred_lang>
<second_last_name>Silva</second_last_name>
<start_date>1983-10-28</start_date>
</personal_information>

<other tags>

------