Extract schedule – Default the effective date parameter based on the payroll relationship group

Summary:

We have to default the effective date parameter based on the payroll relationship group.

For the US country, we have different payroll relationship groups categorized based on the pay period end date.

Sample:

payroll relationship groups1 - pay period end date is 29 July 2024

payroll relationship groups2 - pay period end date is 01 Aug 2024

Example:

While submitting the extract – if selected the group1 then automatically effective date should populate as 29th July

if selected the group2 then automatically effective date should populate as 01th Aug

to achieve the above requirement I have tried value set logic instead of date as display format in the refine extract page, while submitting the extract effective date getting as the list of values, which we can not able to default.