JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Need a calculated calendar field, i.e. Date of Submission + 3 BUSINESS week daysAsked 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?
Date of submission date calculation
Please review the solution provided by Abajan on this thread
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
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.
Institute for Analytic Journalism -- Santa Fe, NM USA
Society of Professional Journalists
*Check out It's The People's Data
I got your latest response. Allow me more time to come up with a solution.
I'll get back to you within today.
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