Skip to main content

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

  • November 17, 2020
  • 2 replies
  • 96 views
A

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!

N
M

2 replies

M

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

N
A
  • Antonia_Lavende
  • Author
  • Participating Frequently
  • November 25, 2020

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

Terms & ConditionsAccessibility statement