5 Replies Latest reply on May 23, 2016 12:39 AM by Ajeet ...

    Level of Detail Help

    Ajeet ...

      Hi Guys,

       

      I have a table like this:

       

         

      IDstatusLast Update Datecentre name
      1701-MayA
      1801-MayA
      1702-MayA
      1802-MayA
      1703-MayA
      1903-MayA
      2703-MayA
      2903-MayA
      3703-MayB
      3703-MayB

       

      The data in ID column is repetitive. Last update Date Column is recording every scan on every ID. 

      I would like to create a date difference between: (Last Update Date of status = 7) AND (Last Update Date of status = 9). So, if status 7 and 9 of an ID is done on same day then 1 Else ) End.

       

       

      Any help pls ???

       

      Regards,

      Ajeet