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

    Calculated completion date base on current date as starting date

    Asked by gymdo on August 05, 2014 at 09:46 PM

    I would like my completion date field (form calculation widget) to be auto calculated 56 days after the Commencement date (datetime tool.) I followed the date string function instructions i.e. datestring(commencementdate+ 56) on the calculation widget but it's displaying a completely incorrect date. Can someone please help with this issue?

    Page URL:
    http://form.jotform.co/form/42158639510859

    Screenshot
    date field form calculation tool datestring
  • Profile Image
    JotForm Support

    Answered by jonathan on August 06, 2014 at 05:02 AM

    Hi,

    It seems that the calculation will not work if you set the DateTime field to Read-Only mode.

    Try setting the Read-Only property to "No" and it should work.

    Here is my test form that you can also try http://www.jotform.me/form/42172383556457

    As you can see it calculates properly by adding 56 days to the current date.

     

    Since you want to locked the current date of DateTime field, you can hide the mini-calendar icon so that it cannot be used.

    You can hide it using custom injected CSS code.

    Try this code

    #input_17_pick{visibility:hidden;}

     

     

    If you test my demo form, you cannot change the DateTime value.

     

    Hope this help. Inform us if you need further assistance.

    Thanks!

     

     

  • Profile Image

    Answered by suportezapsul on December 26, 2014 at 11:27 AM

    Hi!

    I'm trying to add a new field with five days apart from the creation date and I'm not getting, could tell me what I'm doing wrong?

    This message always appears:

    "If output is datetime field, source must also be."

  • Profile Image
    JotForm Support

    Answered by Charlie on December 26, 2014 at 11:48 AM

    Hi suportezapsul,

    To further assist our users, we keep one topic per thread, this would let us focus better on your concern or question. Please refer to this link for the concern you mentioned above, http://www.jotform.com/answers/482449. For future concerns and questions, please open up a new thread here in the forum.

    Thank you.