Jump to content

Xpath formula for filtering Max Date of multiple dates in Iteration Process


suri b

Recommended Posts

I am looking for how to pick the max date from multiple dates in Iteration Process.

My End dates are as following and I am expecting 2020/05/17 as output value which is latest end date or span

a 2018/01/01 2018/12/31

b 2020/01/01 2020/05/14

c 2020/05/15 2020/05/17

Every time iteration process randomly picks the first value that go throughs.Can some one suggest whatxpath formula i can use inorder to pick the max date

 

Currently I am using following formula, which picks randomly,

tib:compare-date( $CurrentMemberAttribute/pfx5:MemberAttributeValue/pfx5:EndDate,current-date())

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...