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
Jan 29, 2021 06:56 AM
Hi, I’m trying to come up with a formula ({FIELD} + 30 days - today’s date.) This seems to be an easy one but I’m missing something. Any ideas?
Jan 29, 2021 09:21 AM
The exact answer is going to depend on what exactly {Field}
is. You can probably figure out the answer yourself from the following:
DATEADD(TODAY(), -30, 'days')
^ That gets you “30 days ago”. If {Field}
is supposed to increase the number “30”, then adjust the formula to -(30 + {Field})