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?


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:


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 :smiley:


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