Formula that defines age at given day

[Mikko_Mantere]

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

[JonathanBowen]

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

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]

JonathanBowen:

DATETIME_DIFF({Date of Test}, {Date of Birth}, ‘months’)

SUPER!

thanks @JonathanBowen !