Skip to main content
Solved

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

  • Aug 30, 2022 8:27 AM UTC
  • 2 replies
  • 112 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

View original
This topic has been closed for replies.

2 replies

TheTimeSavingCo
Forum|alt.badge.img+32

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


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


Bingo! it worked :slightly_smiling_face: thanks so much