4 Replies Latest reply: Sep 3, 2011 3:49 AM by lindabeale RSS

    Finding First and Last Records in a group

      I have data that has an ID, a Stage and a Date.

      I need to calculate the days for each ID between the Stages.

      The data is sorted into the fields and I need to have code to identify the first date in an ID (Lead) and track the date when the Stage changes and then calculate the days difference (which should be a problem).

      The difficulty is getting the right functions to access the first and last record in a group.

      Any help is gladly appreciated.

       

      Lindab