AnsweredAssumed Answered

subtract date of current record from the first one per customer

Question asked by ykoutroulis on Sep 26, 2016
Latest reply on Sep 26, 2016 by philmodjunk

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

Outcomes