Return Max Date Value from Array

[terrylynnd]

Hi, I am not sure this is the best question for what I need, but I'll explain as best I can.   What I need is more detailed than what I will explain, but I just need to get started for now.  By the way, I am VERY new to iReports.

I have a list of values in a field.  I need to break the field down into arrays of some sort and determine the current status.  In the example below, I need to place the Budget Items and Dates in the "Budget_Status" array and the Quote Items and Dates in the "Quote_Status" array.  The current status will be the "Budget_Status", since Budget Received contains the most recent date.  It is okay if the current status is a statuc field of its own, as I am thinking this will work best grouped.  Does this make any sense?  I hope someone can help with this as I am not sure how to search for help on this.

For Example:

Checklist Item                         Checklist Date

Budget Sent                           1/1/2015

Budget Received                   1/6/2015

Quote Sent                             1/3/2015

Quote Reviewed                    1/4/2015

Quote Received                     1/5/2015

 

Thanx so much for time.

[todaydad]

what's your original data, and what's your desired result, please show it.