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   



        2                                       1/4/2014                         3

                                                 1/10/2014                       6


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