Calculated completion date base on current date as starting date

  • gymdo
    Asked on August 5, 2014 at 9: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?

    Jotform Thread 412474 Screenshot
  • jonathan
    Replied on August 6, 2014 at 5: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.

    Calculated completion date base on current date as starting date Image 1 Screenshot 40

    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.

    Calculated completion date base on current date as starting date Image 2 Screenshot 51

     

    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;}

     

    Calculated completion date base on current date as starting date Image 3 Screenshot 62

     

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

     

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

    Thanks!

     

     

  • suportezapsul
    Replied 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."

    Calculated completion date base on current date as starting date Image 1 Screenshot 20

  • Charlie
    Replied 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.