Help

How to calculate years of age knowing birth date

12431 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.