Formular for showing age on a specific Date

[Daniel_Edo]

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 !

[W_Vann_Hall]

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

[Tuur]

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