Filter the task with the MAX Go Live date for each project

[_Manish_Singh]

I have four task bundles, and I want to filter out the task with the maximum date for each project. Any suggestions on how to achieve this?

Task bundles (each project has got multiple Go Lives)

Task	Project	Go Live Date
Task A	Project 1	01-Jan-2023
Task B	Project 1	01-Feb-2023
Task C	Project 2	01-Mar-2023
Task D	Project 2	01-Apr-2023

Expected Output:

Task	Project	Go Live Date
Task B	Project 1	01-Feb-2023
Task D	Project 2	01-Apr-2023

My approach: 
1) Apply dateDifference(Go Live Date;now)
2) The task with MAX date will have max date difference
3) Now I either need to numeric aggregate with project grouping to get MAX dateDifference record or somehow filter out unnecessary records. Need suggestion on how to proceed from here.

[_Manish_Singh · Accepted solution]

I've figured out that I can achieve this by using an array aggregator, then sorting the resulting array based on date difference, and then using the `get()` function along with the `length()` function to obtain the last record in the sorted array.