Age displaying 47 always on my form. Why?

  • DavidGrayTV
    Asked on July 23, 2017 at 2:19 PM

    Hi guys, Can you please check and correct my form calculations for the age of the bride and groom. Irrespective of the year that is entered the same age result of 47 years old always occurs.

  • Kiran Support Team Lead
    Replied on July 23, 2017 at 3:24 PM

    I have checked your JotForm and see that the calculation is done based on two date field. However, the date of birth is being collected on a different field. 

    Age displaying 47 always on my form Screenshot 30

    Since the Brides date of birth field is not sending the field data to the Date of Birth, it is not displaying the correct value. You may setup a new condition on the form to copy the Brides date of birth field data to Date of birth as shown below:

    Age displaying 47 always on my form Screenshot 41

    This should calculate the date difference correctly. You may setup similar condition to the Groom fields as well.

     

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help. 

  • DavidGrayTV
    Replied on July 25, 2017 at 3:12 PM

    I did exactly as you described above but the response is still the same :(:(:( I did reply via the email with an attachment but nobody ever gets back and seeing as there is no attachment upload feature here I will not hold my breath for a quick efficient response as it has already been two days now.

  • Mike_G JotForm Support
    Replied on July 25, 2017 at 3:54 PM

    In order for me to check the issue that is happening in your form, I have created a clone version of it in my account. The issue you are having can be fixed by following the steps below.

    From the builder page of your form, click the condition icon of the "Brides date of birth" (Birth Date Picker widget).

    Age displaying 47 always on my form Screenshot 50

    The conditions associated with the field will show. Edit the condition that copies value of that field to the "Date of birth" field.

    Age displaying 47 always on my form Screenshot 61

    Change the condition's action from "Copy a field's value" to "Calculate a field's value".

    Age displaying 47 always on my form Screenshot 72

    Upon changing the option, notice that the "Brides date of birth" icon in the calculation area is set to "A-Z". Please update that by clicking the icon to "0-9" to indicate a numeric value that will be used for the calculation. — Conditional-Logic-Inserts-Text-Calculation-Into-A-Field

    Age displaying 47 always on my form Screenshot 83

    Save the condition and test your form after.

    If you have other questions or concerns, please feel free to contact us again anytime.

  • DavidGrayTV
    Replied on July 25, 2017 at 3:57 PM

    Seeing as though you have already done the hard work can you please just do it for me please I'll buy you a drink

  • Mike_G JotForm Support
    Replied on July 25, 2017 at 4:15 PM

    As you have requested, I have made the changes to the conditions associated with the "Brides date of birth" and "Grooms date of birth" fields in your form.

    Please check your form and let us know if you have other questions or concerns.