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

    Adding days to a date field and exporting to another date field is broken

    Asked by bcollins33 on December 04, 2014 at 10:48 AM

    I have 2 fields, a start date and an end date. When someone fills in the start date, I want the end date to populate with a date that is 1 week after the start date.

    So I'm going into the "Conditions Wizard" and using the "Update a form field value" option.

    I start with the condition, "If {start date} is filled"

    Then my equation is: datestring( {beginning date} + 7)

    Then I try to output that into the End Date field

    But I get an error saying: "If output is datetime field, source must also be."

    I'm not sure what I'm doing wrong.

    Kade: Usually with the datefield we were primarily using {datefield} + 7. I will have to check it to see if I can figure it out, please allow me a few minutest to look into it more for you

    Sure, that would be great.

    Any word on this yet?

    Kade: Unfortunately no, I've tried a few different ways but so far the alternative methods I tried aren't working either at the moment. I think it will be necessary to open up a thread about this in our forum so that we can research this more to try to find a feasible solution to this matter.

    OK. Is that something I need to do? Or can you open up the thread?

    Kade: You can do this here http://www.jotform.com/answers/answer.php

    date field and JotForm DateTime field style source
  • Profile Image
    JotForm Support

    Answered by Charlie on December 04, 2014 at 12:05 PM

    Hi,

    Unfortunately, I've tried it on my end but I was unable to make it work. This is because adding days, months or years in a date field and outputting it in the same format is not possible right now.

    However, the dateString does work but it computes and output the result in a text string. 

    You can see a sample cloned form that I made here:

    http://form.jotformpro.com/form/43374434410953 

    You can clone it using this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

     

    This might be an alternative, but I think what you are looking for is an output in the actual date field? I still have in mind one workaround but I still haven't tested it yet. I'll get back to you if it works in my end.

    Thank you.