I hope everyone is keeping well given the current pandemic.
I have recently started to use Airtable Sync and since then, noticed a couple of my formulas are now showing up with #ERROR (see pics attached).
My database is a paid plan, but is syncing to a free database. The DOB is being synced to the new page, but the age is not.
I would love some help on how to get the age to show again! Thank you so so much!
Solved! Go to Solution.
It fails for me when I use Today() as the first parameter, but not if I use that as the second parameter. As a temporary workaround, switch the location of Today() and Birthday in both phrases in the formula, then put a minus sign in front at the very beginning. Here’s what the successful formula will look like:
-DATETIME_DIFF(Birthday, TODAY(), ‘years’) & ‘years, ’ & MOD(DATETIME_DIFF(Birthday, TODAY(), ‘months’),12) & ’ months’