Automatically set a date considering the excluded days/dates?

  • oppgraphics
    Asked on March 4, 2016 at 3: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?

  • David JotForm Support Manager
    Replied on March 4, 2016 at 6: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:

    Automatically set a date considering the excluded days/dates? Image 1 Screenshot 30

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

    Automatically set a date considering the excluded days/dates? Image 2 Screenshot 41

    Let us know if you need more help.

  • oppgraphics
    Replied on March 8, 2016 at 9:55 AM

    That worked perfectly. Thank you!

  • Kevin Support Team Lead
    Replied on March 8, 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.