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

  • Profile Image
    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
    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
    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.

  • Profile Image
    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. 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:


    You can test your own form now, and you will see the result:

    Please let us know if you need more help. 

    Note: Keep the replies only to this thread:, so we can properly assist you.