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

  • jtjohnson
    Asked on October 14, 2016 at 6: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

    Jotform Thread 961752 Screenshot
  • jonathan
    Replied 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

  • jtjohnson
    Replied on October 15, 2016 at 5: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
    ============================================
    ...
  • jonathan
    Replied on October 15, 2016 at 9: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.

  • jtjohnson
    Replied 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
    ===================================
    ...