How to calculate years of age knowing birth date


#1

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


#2

You can use this formula:

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


#3

Thank you Andre! Works like a charm!


#4

I believe this equation should do the trick:

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

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


#5

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


#6

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