HCM Extract| Advanced filter criteria

Summary:

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 

 (SELECT min(asg_inner.effective_start_date)

  from PER_ALL_ASSIGNMENTS_M asg_inner 

  where