Age calculation from 2 dates

  • Profile Image
    Asked on May 08, 2016 at 08:15 PM

    Can't seem to get this to work. I want to get the age of someone from two different date fields using the condition feature.  

  • Profile Image
    Answered on May 08, 2016 at 09:03 PM

    Hello rmccoy,

    Why do you want to use condition feature only to calculate age? You can take advantage of our "Form Calculation" widget to achieve your requirement. You need to add following formula to calculate age;

    floor((current date - date of birth)  / 365)

    Please check the screenshot below for all the steps:

    If you want to achieve this through conditions only, you can take advantage of our "UPDATE / CALCULATE FIELD" condition feature. The formula required to calculate age remain same as above. Please check the screenshot below:


    You may also like to take a look the following demo form I created for your: Feel free to clone this form for a closer look. The following guide should help you in form cloning: 

    Hope this helps.

    Do try it out and get back to us if you have any question.

    Thank you!