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

  • Profile Image
    kingfisherweddings
    Asked on February 06, 2016 at 07: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?

  • Profile Image
    Boris
    Answered on February 06, 2016 at 05:41 PM

    We can do that by using conditional logic 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":

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

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

    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.

  • Profile Image
    kingfisherweddings
    Answered on February 07, 2016 at 04: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

  • Profile Image
    BDAVID
    Answered on February 07, 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:

    Now:

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

    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.