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.
Date CalculationsAsked by RogerYelvington01 on April 15, 2014 at 02:44 PM
My employees keep messing up the contract dates, and I would like to have them auto populate based off of other field inputs.
1. Member Start Date - leave as is, currently defaults to todays date (4/15/2014)
2. Member Expiration Date - auto calculate based off of the input from the field
just below titled "Term". So if "12" months is entered, the expiration would be 12
months later than the Start Date (4/15/2015)
3. First Scheduled Payment - default to auto calculate 1 month from the Member Start
date above (5/15/14)
That's possible when you use Form Calculation Widget for the 2 date fields on your form (Membership & First Payment) instead of the Date/Time tool.
Using the dateString function on the calculation wizard, you can add number of days on the entered date from the date field and result it on the calculation field.
Test this form: http://form.jotformpro.com/form/41045859207961?
You can clone this form to find out the the formula. Guide: Cloning-a-Form-from-a-Web-Page
Hope this helps!
Thanks for your reponse. That almost works, but not quite. The day that the member signs up, IE: 04/15/2014, will be their draft day.
Meaning, on the 15th of every month they will be scheduled to pay their member dues - and if the term is two years, they will expire on the same date 04/15/2016.
Because the option you provided does a simply 30 day calculation, this will not show an accurate in many cases, particularly with months that have more or less than 30 days. Any other ideas?
Thank you for your help,
I can only think of downloading the form source and setting a definite date to match the expiration dates like what you mention if your original post that if the start date is 4/15/2014 then chose 12 terms the end date would be 4/15/2015 this is possible if you modify the form source and set the value base on the Terms selected unless some of my colleagues has already a workaround ready for this case.
Let us know if you fine with the form source and we'll also try to make a sample and let you know in this thread.
I have some problems with this date calculation. Is there a way to format the result of the calculation?
I have a hidden Date&Time field which is set to the current date. I need a field with a date 8 days after the current date. I found the solution mentioned by you great, but I would like to format both dates like this: YYYY.MM.DD.
I am trying to create an order form, and I would like to insert the two dates in the notification mail. The first would be invoice date, and the second would be the due date.
Could you please help me to find a solution for this problem?
Thank you in advance,
I have moved your question to separate thread and we will provide you an answer there shortly.
Is there any way to limit a date field to a specific set of dates based on a day of the week? For example, I want my form filler to specify a day of the week (Monday etc) and then based on that, have to pick days that are only Mondays, from say the last 8 weeks and the next 2, giving them a choice of 10 actual dates to pick from, and excluding other dates that don't match the day of the week. That would be AWESOME! It does not have to use an actual date field or calendar - if there is logic that would allow me to simply create a dynamic drop down list of valid dates based on the criteria above (day, and weeks back and ahead) then that would be even better.
I've created a separate thread for you, so anyone in the support staff will be able to assist you with your specific requirement. Please follow up there: