Nov 20, 2017 06:36 PM
I have 100+ children in an orphanage. Knowing the birth date (mm/dd/yr), how can I calculate their age in years to today?
Nov 21, 2017 05:25 AM
You can use this formula:
DATETIME_DIFF(TODAY(),{Date of Birth},‘years’)
Nov 21, 2017 06:09 AM
Thank you Andre! Works like a charm!
Nov 21, 2017 08:30 AM
I believe this equation should do the trick:
DATETIME_DIFF(TODAY(),Birthday,‘Years’)
Just replace ‘Birthday’ with your field name for their birthdays.
Nov 21, 2017 08:31 AM
Woops, disregard my post, the forum site is loading funny for me; didn’t realize this had been answered!
Nov 21, 2017 09:48 AM
The same solution, twice. That has got to be the right answer :grinning_face_with_big_eyes:
Oct 02, 2018 06:14 PM
Is there an easy way to modify this to give the age as of December 01 this season?
Nov 03, 2019 04:32 AM
Anyone know why this formula wouldn’t work? I am getting an formula error message when I try to make a field with this formula. I have changed the field name to match my Birth Date field.
DATETIME_DIFF(TODAY(), {Birth Date}, ‘years’)
Nov 03, 2019 04:56 AM
Hi @Zach_Mortensen
Did you make sure that you use quotes that are straight? Also, that you use the exact name of the field in the formula expression.
When creating a formula you have to setup a second field, using Formula field.
Those are a few things to check.
Mary
Nov 03, 2019 08:13 AM
thank you! must have been the straight quotes. when I retyped each of them instead of pasting them it worked.
