Forum Discussion

RODRIGO_teixeir's avatar
RODRIGO_teixeir
Frequent Visitor
6 years ago

Coluna Calculado

Hello people,
I have the following problems, through my freight and customer issuance table, I was able to identify the number of days by the previous date, in the case if it is greater than 60, the customer is reactivated, but I wanted him to be reactivated for 30 days, I can't get him to verify that he reached 60 days before the last purchase of that date is counted until 30 days after.
.

2 Replies

    • RODRIGO_teixeir's avatar
      RODRIGO_teixeir
      Frequent Visitor

      I'm trying to do the following calculation: I have the table with customer, billing date and billing, I would like to build a condition to search the previous date of the last billing in the context of the line, example: client A, billed on 03/03/2020, previous date 03/01/2020 , with the previous date I would like to return the number of days to know if it is greater than 60 it is in the condition of reactivated as attached, from the date of reactivation I have to add the values ​​up to 30 days after the conditions of activated.