Help

Re: Formula for to show current age

1272 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kimberly_Zenyuc
4 - Data Explorer
4 - Data Explorer

What is the formula for using a birthdate and creating a field to show current age today?

5 Replies 5

Hi @Kimberly_Zenyuch

It’s this:

DATETIME_DIFF(TODAY(),{Birth Date},‘years’)

Hope this helps.

Sajeev_Wagle
4 - Data Explorer
4 - Data Explorer

I am getting error.Can you comment
DATETIME_DIFF(TODAY(),{DOB},‘years’)
It. says Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

@Sajeev_Wagle

DATETIME_DIFF(TODAY(), {DOB}, 'years')

I’m guessing you copy-pasted from @Julian_Kirkness‘s post - Airtable doesn’t like “smart quotes”. Above is the same formula with “dumb quotes” so it’s copy-paste safe.

I just copied the template but i am sure i used single quotes as i typed manually.Its a direct paste from formula bar. I couldnt upload my spreedsheet or screenshot.
DATETIME_DIFF(TODAY(), {DOB}, ‘years’)

Can someone advise where I input such a formula when using the iOS mobile app? I’m starting from scratch and never done anything with formula before.

I also have a DOB field and want to add an age field based on DOB. Any help would be appreciated.