Skip to main content

Formular for showing age on a specific Date

  • April 13, 2018
  • 2 replies
  • 27 views

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 !

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+5
  • Inspiring
  • April 13, 2018
DATETIME_DIFF(
    DATETIME_PARSE('17.08.2018','DD.MM.YYYY')
    ,Geburtdatum, 
    ‘years’
    )

Tuur
Forum|alt.badge.img+20
  • Inspiring
  • April 13, 2018

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