Calculated completion date base on current date as starting date

  • Profile Image
    gymdo
    Asked 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?

  • Profile Image
    jonathan
    Answered 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
    suportezapsul
    Answered 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
    Charlie
    Answered 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.