Automatically set a date considering the excluded days/dates?

  • Profile Image
    oppgraphics
    Asked on March 04, 2016 at 03:40 PM

    My onboarding form has a due date field that is set to exclude weekends, past days, and a couple specific days; and the date selected automatically sets to 3 days from today.

    I would like the day that is automatically selected to consider the exclusion of weekends and those specific dates. Basically to add 2 BUSINESS days to todays date instead of just regular days...

     

    So for example: if I used the form today (Thursday, March 4th) the due date is being set automatically to Monday, March 7th. The problem is that that is technically only a 1 day difference because the weekend days (Saturday and Sunday) are not available. The due date should be Wednesday, March 9th.

     

    Can someone help please?

  • Profile Image
    BDAVID
    Answered on March 04, 2016 at 06:08 PM

    Unfortunately, that is not supported, what you can do is to create conditions to update based on the day captured in another Date field's current date, example:

    Result: https://form.jotform.com/60636885192970 

    Let us know if you need more help.

  • Profile Image
    oppgraphics
    Answered on March 08, 2016 at 09:55 AM

    That worked perfectly. Thank you!

  • Profile Image
    Kevin_G
    Answered on March 08, 2016 at 12:09 PM

    On behalf of my colleague, you're welcome. 

    Do not hesitate to contact us if you need more help, we will be glad to assist you.