Skip to main content

Formula for to show current age

  • October 26, 2017
  • 5 replies
  • 32 views

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

5 replies

Forum|alt.badge.img+4
  • Inspiring
  • 485 replies
  • October 26, 2017

Hi @Kimberly_Zenyuch

It’s this:

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

Hope this helps.


  • New Participant
  • 2 replies
  • October 15, 2019

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.


Forum|alt.badge.img+18
  • Inspiring
  • 1691 replies
  • October 15, 2019

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.


  • New Participant
  • 2 replies
  • October 15, 2019

@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’)


  • New Participant
  • 1 reply
  • June 15, 2020

Hi @Kimberly_Zenyuch

It’s this:

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

Hope this helps.


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.