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

    Date Calculations

    Asked by RogerYelvington01 on April 15, 2014 at 02:44 PM

    Hey Guys!

    My employees keep messing up the contract dates, and I would like to have them auto populate based off of other field inputs.

    IE:  

    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) 

     

    Thank you!

    Page URL:
    http://www.jotformpro.com/form/40195970336963

    calculations start date expiration date 3 and
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 15, 2014 at 04:07 PM

    Hi,

    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.

    Example:

    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!

  • Profile Image

    Answered by RogerYelvington01 on April 15, 2014 at 05:24 PM

    Hello!

     

    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,

     

    Roger

  • Profile Image

    Answered by jedcadorna on April 15, 2014 at 10:18 PM

    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.

  • Profile Image

    Answered by proba1 on August 03, 2015 at 03:43 PM

    Hi!

     

    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,

    Akos

  • Profile Image
    JotForm Support

    Answered by BJoanna on August 03, 2015 at 04:36 PM

    @proba1 

     

    I have moved your question to separate thread and we will provide you an answer there shortly. 

    https://www.jotform.com/answers/627189 

  • Profile Image

    Answered by wiltshs on October 12, 2015 at 12:58 AM

    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.

    Thanks

    http://www.jotform.com//?formID=13632031648#

  • Profile Image
    JotForm Support

    Answered by beril on October 12, 2015 at 08:37 AM

    Hi,

    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:

    http://www.jotform.com/answers/678341472

    Thank you.