Skip to main content
Topics#Sales And MarketingEmma Trotman's Question
Emma Trotman (Talking Talent) asked in #Sales And Marketing
Jul 22, 2020, 10:08 AM

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 answer
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Jul 22, 2020, 10:10 AM
    Hi Emma,

     

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

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

     

     
Write an answer...
0/9000