2 Replies Latest reply on Nov 30, 2016 2:06 PM by Jonathan Drummey

    Datediff between 2 dates in same column

    Sushma Nayak

      I need to find the time taken to complete a ticket.

      I have below table

       

      TicketdateStatus
      19/26/2016New
      19/28/2016In Progress
      19/29/2016Completed

       

      I want date diff where start date is 9/26/2016 (status = new) and end date is  9/29/2016 (status = completed) per ticket.

       

      Is there any way to do it?