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

    Calculating the next calendar birthday.

    Asked by SpiritofGeorgia on December 09, 2015 at 01:12 PM

    I have a form that is asking for the date of birth. Calculating the age is not a problem.

    What I would like is a hidden field with the next birthday to use in the Calendar Report. I just can't come up with a working formula for updating that field value. Any ideas?

    next Calendar Report problem hidden date of birth
  • Profile Image

    Answered by SpiritofGeorgia on December 09, 2015 at 02:24 PM

    Took a bit more cogitation...
    This has to be a Date field with an update field condition. Form Calculation will not work. I've noticed some dates are one day off, but this works well to populate the Calendar Report to show birthdays for upcoming year.

  • Profile Image
    JotForm Support

    Answered by Mike_G on December 09, 2015 at 05:20 PM

    Thank you for the update. To my understanding, you want to pass the value of the "Next Birthday" date field to a hidden text field is that correct? I can see that you were able to create a formula that will calculate for the next birthday and it is working as I have tested it. I have cloned your form and created a Calendar report. Everything seems to be working fine. Is there anything else that you need to do that we can help you with? Please feel free to let us know should you have any other questions or concerns. Thank you.