5 Replies Latest reply on Feb 7, 2014 12:30 PM by Aaron Clancy

    How can I calculate the difference in dates along a single column of dates?

    Austin Barry

      I have multiple Distinct CustomerIDs each with a set of TransactionDates. These transaction dates are one column and I want to calculate the difference between transaction dates for each CustomerID to ultimately come up with Transaction Cycle Time.

       

      I can attach an example file, but below is a rough look at the data I have.

       

      CustomerID                         TransactionDate               DateDiff

      1                                        1/1/2014

                                                1/3/2014                          2   

       

                                                 1/1/2014

        2                                       1/4/2014                         3

                                                 1/10/2014                       6

       

      It's this DateDiff field that I ultimately want to calculate.