Skip to main content
Topics#Sales And MarketingFrage von Emma Trotman
Emma Trotman (Talking Talent) fragte in #Sales And Marketing
22. Juli 2020, 10:08

How to create a field to show how many days overdue an invoice is?

I'd like to create a field formula that calculates how many days overdue an invoice is (using it's due date) Thanks! 
1 Antwort
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    22. Juli 2020, 10:10
    Hi Emma,

     

    Create a formula field returning a number (change DueDate to the API name of your field):

    IF(DueDate>=TODAY(),0, TODAY()-DueDate)

     

     
Antwort schreiben...
0/9000