Forum Discussion

MW_TSC's avatar
MW_TSC
Frequent Visitor
2 years ago
Solved

Calculating Overdue Dates based on a Column Value

Hi!

I am trying to create a dashboard for different visuals around customer payments - this visual is specifically for whether or not a payment is overdue, however there are different variables based on domestic and commercial customers.

 

Commercial customers have 30 days after the invoice date before payment is due

Domestic customers have 14 days after the invoice date before payment is due

 

I have got to this stage in my formula creation where no syntax erros have been detected, however the column is still returning "Error" down all lines.

 

Please can anyone help? Screenshot below:

 

 

 

 

 

Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    Hi MW_TSC,

     

    You can't add numbers and dates, these are two different types of values

    Use the Date.AddDays function instead.

     

    To illustrate:
    Date.AddDays( [Invoice Date], 30)

2 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    2 years ago

    Hi MW_TSC,

     

    You can't add numbers and dates, these are two different types of values

    Use the Date.AddDays function instead.

     

    To illustrate:
    Date.AddDays( [Invoice Date], 30)