How to exclude weekends when using dynamic date selections?

  • Profile Image
    VCSIT
    Asked on December 11, 2020 at 07:15 PM

    Hi,

    I've created a form for work in which students can request a transcript. We advise them that the requests take no less than 3 business days to process. We ask them to tell us their desired date to pick up their transcript. I am using the calendar picker in the form and i have excluded weekends since these are not business days. I learned that i can use Dynamic Date Selections and choose today+x (where x is the number of days to be added to today). This mostly works, except it counts the weekend days. How can i exclude the weekends in this calculation?

    Thanks in advance for your help!

    Mike



  • Profile Image
    Vick_W
    Answered on December 11, 2020 at 11:08 PM

    Hi Mike,

    For the Date field settings, all the days that will result in a working day when 3 working days are added we will use the date field with the following settings.

    1607743815_5fd43947daf04_

    Here is how the result will show. The user will only get one day to pick. You can change it based on your requirement.

    1607743963_5fd439db76b95_

    Now the most important step is to add a date field and activate the CURRENT DATE option in it. This field will remain hidden and it will be used as the main trigger point for all the conditions.

    1607745933_5fd4418d01795_

    Now you'll have to add multiple date fields in order to avoid showing the weekends using conditions. For example, if the day is Wednesday then the 3rd day will be Saturday. But to show the next working day which is Monday you'll have to add +5. You can use this one condition for Wednesday, Thursday, and Friday.

    Here is how you will create the show/hide condition.

    1607744437_5fd43bb5593cb_

    1607744488_5fd43be80c2a1_

    Now for example, if someone is placing the order on a Saturday then you'll need the date to add +4, so you'll need another date field in which you'll use Today+4 for both start and end date. You'll have to add conditions for this as well.

    I've created a clone for you. You can test it and clone it from the link below.

    https://www.jotform.com/203458083155960

    You can clone it using the guide below.

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Please try it and if you have any questions then please let us know.

    Thanks