HCM Extract| Advanced filter criteria
I am working on an extract, where the business requirement is to fetch the oldest_assignment who falls between financial start date and financial end date.
In the assignment data group under advanced filter criteria, I gave below condition but it is not working, could you please let me know where the issue is?
Financial Year is ( 6 April to 5 April)
Effective Date Parameter - Always financial end date which is 5 April YYYY will be passed
Advanced Filter Criteria-
and asg.effective_start_date in
from PER_ALL_ASSIGNMENTS_M asg_inner