How to label costumer status base on transaction_date?

Copper Contributor

Hi everyone, i'm doing my homework and struggling with this question. 

How to determine customer_status (new/current)

- When transaction orders in the month of the first order => New

- When transaction orders before the month of the first order => Current

 

=> What function should I use in this circumstance :facepalm: thanks a lot 

 

costumer_idorder_idTran_dateFirst_tran_dateType_user
1900041695176262029-01-152019-01-01 
1900141695176272020-01-012020-01-01 
1900241695176282020-05-132020-01-02 
1900341695176292020-05-142020-05-03 
0 Replies