11 Replies Latest reply on Jun 4, 2015 12:55 PM by Cyril Belmehdi

    Number of days between a ship date on row #1 and the next order date on row #2

    Joel Hughes

      Using the Superstore Sales data set, I'm attempting to determine the number of days, by customer, between a ship date and the immediate next order date and have these two dates be on the same line, if possible. For example, Aaron Bergman's first order shipped on February 25, 2011, and his next order date was 10 days later on March 7, 2011.

      Capture.PNG

       

      The ideal row setup would look like this:

       

      Previous Order Ship DateCurrent Order DateDays to Order
      February 25, 2011March 7, 201110

       

      I searched the forums and really wanted to find the answer here FAQ:  Open & Close Dates but without success. Any help would be greatly appreciated. Thank you!