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 base...
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)

MW_TSC's avatar
MW_TSC
Frequent Visitor
2 years ago

That's great, thankyou!