How to set a date field to be 90 days before another date

  • kingfisherweddings
    Asked on February 6, 2016 at 7:46 AM

    How do i input a second date that is 90 days earlier than the first?

    In the screen shot attached I am needing the expected pay date to be 90 days earlier than the date inputted in the date of wedding field.

    Can this be done and if so how please?

    Jotform Thread 766116 Screenshot
  • Boris
    Replied on February 6, 2016 at 5:41 PM

    We can do that by using conditional logic with your form with Insert rules - to insert a date that is 90 days before one date into another date field.

    What I have done on my demo, is I have first added another date field named "Expected Date of payment":

    How to set a date field to be 90 days before another date Image 1 Screenshot 40

    Then, I have set up a condition to insert value of "Date of the wedding" field minus 90 into this new field:

    How to set a date field to be 90 days before another date Image 2 Screenshot 51

    The result is this, where the second date field is automatically filled when a date is set in the first field:

    How to set a date field to be 90 days before another date Image 3 Screenshot 62

    Please let us know if this works to satisfaction, or if you hit any snags while setting it up, and we will be happy to help.

  • kingfisherweddings
    Replied on February 7, 2016 at 4:37 AM

    nope. Copied everything exactly as you said but still after 4 days nothing works, seriously thinking of looking elsewhere. Here is the form if you think you can pursauade me.

    https://form.jotformeu.com/60366076191355

  • David JotForm Support Manager
    Replied on February 7, 2016 at 12:31 PM

    I see that you have asked the same question in more that one thread, which have been provided with a solution.

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

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

    http://www.jotform.com/answers/766116(the last one you have replied)

    We do ask to open an stay in one thread per issue, and keep replying to that thread to avoid any confusion and to have a good sequence of the work provided.

    I have cloned your form and fixed what you currently have:

    Your condition before:

    How to set a date field to be 90 days before another date Image 1 Screenshot 40

    Now:

    How to set a date field to be 90 days before another date Image 2 Screenshot 51

    You can test your own form now, and you will see the result: http://www.jotformeu.com/form/60366076191355

    How to set a date field to be 90 days before another date Image 3 Screenshot 62

    Please let us know if you need more help. 

    Note: Keep the replies only to this thread: http://www.jotform.com/answers/766116, so we can properly assist you.