5 Replies Latest reply on Mar 5, 2016 8:00 PM by Aditya Naidu

    Finding Max

    Ajeet ...

      Hi guys,

       

      I need your help to find a string based on its updated feature. In the following sheet, for an Airwaybill, based on the latest date and time in the field "updated on(service centre shipmenthistory" , I need to get the string value from the Current Sc Field. In this case the answer would be  'RAIPUR - RPH'  for Airwaybill 156790656.

       

       

      Capture.PNG

       

      I have attached the working file.. Any help would be greatly appreciated...

       

       

      Regards,

      Ajeet