2 Replies Latest reply on Dec 4, 2018 2:32 AM by AJ.Yusuf

    Find the Min or Max which is greater then a Certain value


      Hi All


      I have a data set whch has "DATETIME of Count field"

      I would like to look in the "Time of Movement" field and find the next time whcih grater then the "DATETIME of Count field" AND THE GREATEST TIME before


      for example

      For the Number = AF65VEO"


      The time of the movement after the "datetime of count" field =20/11/2018 16:30:00


      So Name = Ste


      and the time before is



      I would like to identify this for a large amounbt of records



      is it possible to get a simple wortksheet with


      above example


      Number           Name before Count     Name After count

      AF65VEO           Ste                                   Uni