Skip to main content

Formular for showing age on a specific Date

  • April 13, 2018
  • 2 replies
  • 23 views
D

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 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • April 13, 2018
    DATETIME_DIFF(
    DATETIME_PARSE('17.08.2018','DD.MM.YYYY')
    ,Geburtdatum, 
    ‘years’
    )
    T
    Forum|alt.badge.img+19
    • Tuur
    • 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:

      Terms & ConditionsAccessibility statement