Skip to main content
Topics#Sales And MarketingEmma Trotman의 질문
Emma Trotman (Talking Talent) 님이 #Sales And Marketing에 질문했습니다
2020년 7월 22일 오전 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개
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2020년 7월 22일 오전 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)

     

     
답변을 작성하세요...
0/9000