7 Replies Latest reply on Oct 11, 2019 11:23 AM by Madeleine Mindling

    Find previous order date from filtered worksheet

    Madeleine Mindling

      Hi there,


      I want to add a 'Previous Order Date' column to this worksheet that indicates the previous order date for each customer using the 'Order Date' as a reference. The 'Order Date' is not necessarily the customer's min or max Order Date. I just want to know when was their last order date compared to 'order date' that shows up in the view.