2 Replies Latest reply: Dec 19, 2016 12:51 PM by Rob Wunderlich RSS

    How to calculate number of days between each status change per transaction as a field in the script?

    John Blomqvist

      Hi all,

       

      I have some transactions data table which looks like this:

       

      DateTransactionIDStatusNameDuration (This field to be created)
      08-Mar-142001Completed7
      08-Mar-149342Completed7
      05-Mar-142001Started4
      05-Mar-149342Started4
      01-Mar-142001Open0
      01-Mar-149342Open0

       

      I would like to create the Duration field above in the script where it calculates the number of days it took between each status per transaction.

       

      Does anyone know how I can do this please? A working code would be great