1 Reply Latest reply on Sep 26, 2016 1:50 PM by philmodjunk

    subtract date of current record from the first one per customer

    ykoutroulis

      Hi,

       

      I have a table with customers and another one with orders. What I want to do is the following:

       

      I want to calculate the number of days between the current record and the date of the first transaction of the specific customer (I need to do some search here but I am not sure how) .

       

      thank you