Help

Formula that defines age at given day

Topic Labels: Formulas
2008 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mikko_Mantere
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey!

I´m new in this and also not much of a nerd :slightly_smiling_face:

I’m trying to create a database for recording athletes test results. I have one table for athletes and another for results. I want to determine the age of Athlete at the time of the test. In “results” table I have a testing day field

The “age at testing day” field should show the age in years or if possible the years + months (example
13 years 4 months)

I´m grateful for all the help

2 Replies 2

Hi @Mikko_Mantere - here’s how to do this:

Screenshot 2019-04-10 at 14.44.52.png

I’ve got 4 formula fields (you can hide the fields you don’t want to see):

Months:

DATETIME_DIFF({Date of Test}, {Date of Birth}, 'months')

Whole Years:

INT(Months/12)

Remainder Months:

MOD(Months, 12)

Age at test:

{Whole Years} & ' years ' & {Remainder Months} & ' months'

JB

Mikko_Mantere
5 - Automation Enthusiast
5 - Automation Enthusiast

SUPER!

thanks @JonathanBowen !