Formular for showing age on a specific Date


#1

Hi, i am Ising this formula for showing thebagenof a person. What do I have to change to Show the age on for example the 17.08.2018.

DATETIME_DIFF(TODAY(),Geburtdatum, ‘years’)

Thank you !


#2
DATETIME_DIFF(
    DATETIME_PARSE('17.08.2018','DD.MM.YYYY')
    ,Geburtdatum, 
    ‘years’
    )

#3

Or switch the {TODAY()} part for a {myDate} field in your table that will easily let you change it… :slight_smile: