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.
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?
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.
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.