How to calculate years of age knowing birth date

You can use this formula:

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

Thank you Andre! Works like a charm!

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:

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

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.

Hi @Zach_Mortensen

I am glad to know it worked.

Mary