Skip to main content
Solved

How can I calculate invoice due date based on invoice issued date + 30 days

  • August 30, 2022
  • 2 replies
  • 42 views

Hi I would like to add a formula field which calculates when an invoice is due for payment. I have an ‘invoice issued’ date field and would like to use that to calculate +30 days.
this is where I have got to but its returning an error

DATEADD({Date Invoice Raised} +30,‘day’)

many thanks
Clare

Best answer by Clare_Fitzpatri

Hi Clare, could you try: DATEADD({Date Invoice Raised}, 30, 'days')?


Bingo! it worked :slightly_smiling_face: thanks so much

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hi Clare, could you try: DATEADD({Date Invoice Raised}, 30, 'days')?


  • Author
  • Inspiring
  • 5 replies
  • Answer
  • August 30, 2022

Hi Clare, could you try: DATEADD({Date Invoice Raised}, 30, 'days')?


Bingo! it worked :slightly_smiling_face: thanks so much