Skip to main content
Topics#Sales And MarketingQuestion de Emma Trotman
Emma Trotman (Talking Talent) a posé une question dans #Sales And Marketing
22 juil. 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 réponse
  1. Forum Ambassador Eric Praud (Activ8 Solar Energies)
    22 juil. 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)

     

     
Rédiger une réponse...
0/9000