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

    Calculate Date Difference for each ID

    Jean Francois Carton



      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