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

  • Profile Image
    jtjohnson
    Asked 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

  • Profile Image
    jonathan
    Answered 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
    jtjohnson
    Answered 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
    jonathan
    Answered 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
    jtjohnson
    Answered 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
    ===================================
    ...