1 Reply Latest reply on Oct 18, 2013 7:05 PM by Kyle Pipkins

    Calculate Date Difference for each ID

    Jean Francois Carton

      Hello,

       

      Another tricky problem!

      I would like to calculate the date difference between 2 dates (very easy), but only when the dates are different:

       

      ID2     12/31     04/05     xx days

      ID2     12/31     04/05   

      ID2     12/31     06/08     xx days

      ID2     11/30     04/05     xx days

       

      In this case when I will need to count the number of cases with xx days, it will just give me the cases with a different date, and not count me the duplicate.

       

      Ideally it would be something like that:

       

      Date Diff (Start Date, End Date) for each REPORT ID