I am trying to get the most recent hearing date that is sorted by the current hearing officer. I am also trying to sort by age, so I can help prevent them from becoming late.

Hearing Officer
Client ID
Appeal # (1 to many)
Hearing #(can be many if rescheduled = R)
Hearing Date = should be currentdate-1 for this report.
Timely = less than 30 days unless there is an R or an exception - then it is timely if done within 90 days.

I have tried to give all the fields and as much info as possible to help solve my issue.

I have the timely formula for 90 days with R or exception, but I have hearings pop that are untimely with an O that have not been rescheduled.


Edited by Babea - 14 Mar 2012 at 9:02am