Skip to main content

How to calculate years of age knowing birth date


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

You can use this formula:


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


Thank you Andre! Works like a charm!


  • Known Participant
  • 30 replies
  • November 21, 2017

I believe this equation should do the trick:


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


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


  • Known Participant
  • 30 replies
  • November 21, 2017
AlexWolfe wrote:

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:


  • New Participant
  • 4 replies
  • October 3, 2018

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


  • Participating Frequently
  • 5 replies
  • November 3, 2019

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


  • Inspiring
  • 614 replies
  • November 3, 2019
Zach_Mortensen wrote:

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


  • Participating Frequently
  • 5 replies
  • November 3, 2019
M_k wrote:

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.


  • Inspiring
  • 614 replies
  • November 3, 2019
Zach_Mortensen wrote:

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


Reply