What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Need a calculated calendar field, i.e. Date of Submission + 3 BUSINESS week days

    Asked by jtjohnson on October 14, 2016 at 06:20 PM

    This form is a request for public records.  The law stipulates that the public records custodian has to initially reply to the request in no more than three days from the day of submission.  But these are BUSINESS DAYS, that is, the weekend does not count.  

    Any suggestions as to how I can generate a calculated field for the clerks, one that will automatically tell them the deadline date by which they have to respond to the requester?

    Thanks, all.

    Tom Johnson

    Page URL:
    https://form.jotform.com/62305565921152

    Screenshot
    Date of submission date calculation
  • Profile Image
    JotForm Support

    Answered by jonathan on October 14, 2016 at 11:39 PM

    Hi Tom,

    Please review the solution provided by Abajan on this thread 

    https://www.jotform.com/answers/677930-Can-Weekends-be-Excluded-from-the-Results-of-DateTime-Calculations

    For a quick test try his demo form https://form.jotformpro.com/52807289886979

    In the demo form you can see the Due date, but the date counted excluded weekend days (Sat, Sun)

    Let us  know if you need further assistance accomplishing the same result using the solution form that thread

    Regards

  • Profile Image

    Answered by jtjohnson on October 15, 2016 at 05:44 PM
    Thanks, but the example form you suggest doesn't work. For example, today
    is SATURDAY, Oct. 15. If I ask for the date three days in advance, it
    returns Oct. 18, which is, yes, three days ahead but includes Sunday, Oct.
    16 in the count. Again, I need a calculation that excludes the dates
    falling on Saturday and Sunday.
    Tom Johnson
    ============================================
    Tom Johnson
    Institute for Analytic Journalism -- Santa Fe, NM USA
    505.577.6482(c) 505.473.9646(h)
    Society of Professional Journalists
    *Check out It's The People's Data
    *
    http://www.jtjohnson.com tom@jtjohnson.com
    ============================================
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on October 15, 2016 at 09:50 PM

    Hi Tom,

    I got your latest response. Allow me more time to come up with a solution.

    I'll get back to you within today.

    Thanks.

  • Profile Image

    Answered by jtjohnson on October 16, 2016 at 12:44 AM
    Thank you. I would think many users would appreciate -- and use -- a
    calendar tool that would let us select specific days of the week or just
    exclude weekend days.
    Cheers, Tom Johnson
    ===================================
    Tom Johnson - Inst. for Analytic Journalism
    Santa Fe, NM
    tom@jtjohnson.com 505-473-9646
    ===================================
    ...