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.