Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 30, 2022 01:27 AM
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
Solved! Go to Solution.
Aug 30, 2022 01:47 AM
Hi Clare, could you try: DATEADD({Date Invoice Raised}, 30, 'days')
?
Aug 30, 2022 04:30 AM
Bingo! it worked :slightly_smiling_face: thanks so much