Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to calculate years of age knowing birth date

15910 10
cancel
Showing results for 
Search instead for 
Did you mean: 
ARTHUR_BENNETT
5 - Automation Enthusiast
5 - Automation Enthusiast

I have 100+ children in an orphanage. Knowing the birth date (mm/dd/yr), how can I calculate their age in years to today?

10 Replies 10

You can use this formula:

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

ARTHUR_BENNETT
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Andre! Works like a charm!

AlexWolfe
6 - Interface Innovator
6 - Interface Innovator

I believe this equation should do the trick:

DATETIME_DIFF(TODAY(),Birthday,‘Years’)

Just replace ‘Birthday’ with your field name for their birthdays.

Woops, disregard my post, the forum site is loading funny for me; didn’t realize this had been answered!

The same solution, twice.
That has got to be the right answer :grinning_face_with_big_eyes:

Steve_Long
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there an easy way to modify this to give the age as of December 01 this season?

Zach_Mortensen
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

thank you! must have been the straight quotes. when I retyped each of them instead of pasting them it worked.