Skip to main content

Hey!


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


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

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


SUPER!


thanks @JonathanBowen !

Reply


Terms & Conditions