Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: I need to create a formula for age based on date of birth

1183 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Antonia_Lavende
5 - Automation Enthusiast
5 - Automation Enthusiast

It’s pretty simple, but I’m new to this. I need a column that changes the age with the date of birth. So I know I have a columnn called AGE which should change when the child reaches a birthday in a roster. Any help so I can copy and paste a formula would be appreciated.

Thank you!

2 Replies 2
Martin_Stegmark
4 - Data Explorer
4 - Data Explorer

DATETIME_DIFF(TODAY(),{Birthday},'Year')

This formula outputs the age in years. You must have a field called Birthday where you have registered each persons birthdate.

Hope it helps.

//Martin

Thank you! That works!!

Antonia Lavender
310.803.6854
Antonia@AntoniaLavender.com