What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    how to calculate age using condition

    Asked by akmaleddy on January 17, 2017 at 07:43 AM
  • Profile Image

    Answered by Ian on January 17, 2017 at 09:23 AM

    Here is the demo : https://form.jotform.com/61880675038968

    Feel free to clone this form so you can figure out the whole setup.

    Guide: https://www.jotform.com/help/28-Cloning-a-Form-from-a-Web-Page


    Basically, what you need 2 datetime fields and 2 form calculation fields.

    Here are the screenshots: Make sure to enable the default date on the 2 datetime fields.


    You need to define the formula on each of the calculation field.

    The first calculation field (Days) gets the number of days, here's the formula:

    On the second calculation field (Age), this will calculate the Age base from the given birth date of the user using math Floor function.

    If you need further assistance, do let us know.

  • Profile Image

    Answered by akmaleddy on January 17, 2017 at 10:45 AM
    can you give me the formula?
    2017-01-17 21:23 GMT+07:00 JotForm :
  • Profile Image
    JotForm Support

    Answered by BDAVID on January 17, 2017 at 12:03 PM

    The formulas are listed in the step by step example my colleague has provided.


    You can clone his form if you want to: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    URL to the form: https://form.jotform.com/61880675038968 

    Let us know if you need more help.

  • Profile Image

    Answered by akmaleddy on January 17, 2017 at 01:09 PM

    thank u for your help