Date of Birth / Age Error

[Jacqui_Birchall]

Hey All,

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!

[Jeremy_Oglesby]

Formula was working, now it isn't Formulas

Hello! I’ve been using Airtable for a couple years. I don’t know much about formulas, but I can usually figure out what’s going on. In one table, I have this formula to calculate ages: DATETIME_DIFF(TODAY(), Birthdate, ‘years’). Up until today, it’s worked perfectly. However, for some reason, now it’s giving me an error message. I have a different table with the same formula - it’s also giving me a brand new error message. I’ve tried switching the order DATETIME_DIFF(Birthday, TODAY(), ‘years’)…

@Abby_Malesytcki has noted the same issue, and I just checked and am seeing similar errors for DATETIME_DIFF() functions.

@Jason, @Kasra
Your DATETIME_DIFF() function is broken :confused:

[Jason]

Hey @Jacqui_Birchall and @Jeremy_Oglesby,

Thanks for letting us know! We were just finding this out as well. Would you like me to create a support ticket about this for you?

[Jeremy_Oglesby]

:man_shrugging:

…not really; just kinda would like to see it fixed. If it will help your workflow, then go for it.

[Jason]

Jeremy_Oglesby:

…not really; just kinda would like to see it fixed

No problem, I’ll update here once we’ve confirmed a fix.

[Dan_Smellow]

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’

[Jason · Accepted solution]

Hi everyone, this bug should be fixed now. You may need to refresh your screen (or restart your app if you’re using our desktop version) to see the changes.

So sorry for the issue!