Oct 26, 2017 04:34 AM
What is the formula for using a birthdate and creating a field to show current age today?
Oct 26, 2017 07:59 AM
Oct 14, 2019 06:09 PM
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.
Oct 14, 2019 06:33 PM
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.
Oct 14, 2019 07:47 PM
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’)
Jun 15, 2020 04:17 AM
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.