Skip to Content
0
Former Member
Mar 02, 2009 at 09:55 PM

Finding earliest and latest date in a series of records

163 Views

I need to find the earliest "active date" and the last "complete date" in a group of records (Request Tasks) with the same Parent ID.

I was thinking I need to loop through the records but am not sure how to construct the query.

I think I need to have two formulae, one to find the first active date and the second to find the last complete date. Once I have those two dates, I'm confident in the formula I have already constructed in the program to calculate the number of hours. ( I cannot use the dates in the parent record because I need to exclude some of the tasks - that's a whole other story).

In searching the forum for loops, I really only found one thread, but it wasn't helpful.

Any ideas will be most appreciated.