My question is similiar to this question...
I have a set of data with record column, dates coloumn and active/inactive column. However the dates column has past, current and future active dates. How do I set the paramenter to give me just the last inactive date the most current active date...