5 Replies Latest reply on Jun 16, 2016 2:22 PM by Derrick Austin

    Displaying the Maximum Date for repeating data

    Joshua Matlock

      Hi all. I am trying to figure out a way to create a logical statement that will scan the code column, and figure out the maximum date for each code (that might have more than one entry), then summarize which row of the repeating fields has the maximum date with a 1 or a 0 in a column next to value (1 being a row with a maximum date for a certain code, 0 being not a maximum date).

       

      In other words, the maximum date for A = 16/11/2012, for B = 10/11/2012, C = 15/11/2012. The rows for the fourth column would look like:

       

      0

      0

      1

      1

      0

      0

      1

      Any comments would be highly valued. Thank you!