Skip to Content
0
Former Member
Mar 20, 2009 at 08:46 PM

How to display/retrieve related row data on a maximum date formula

13 Views

Here's data for one employee:

Charge Date Work Date Segment

11/05/08 11/28/08 TPLNDD

11/07/08 11/09/08 TPLNDN

11/21/08 11/22/08 TPLNDA

11/26/08 11/29/08 TPLNDN

12/11/08 12/14/08 TPLNDN

I want to calculate the maximum "charge date" where segments in "TPLNDD", "TPLNDA". Then, once this date is selected (11/21/08), I want to pick/retrieve the date which corresponds to that record (11/22/08).

I would like to avoid creating a group for the maximum charge date, because I want to be able to drill down to the details and see all the records.

Thanks, Ada