1. Fidel Castro Armario
  2. JIRA Workflow Toolbox
  3. Issues

Issues

Issue #677 new

Set Due Date by Skipping Weekdays and Business Holidays (Custom Schedule)

jtabatabai
created an issue

Fidel,

I am excited about the new feature that allows us to create a Custom Schedule. I am interested in how I can use this along with the addDaysSkippingWeekends to accomplish setting the due date to skip weekdays and business holidays (as defined in a Custom Schedule). I tried this but it doesn't work as I expected.

Custom Schedule
#2018 Thanksgiving
2017/11/23 - 2017/11/24 {;}

#Annual Holidays
JAN/1, JUL/4, DEC/25 {;}

SkipWeekdaysAndHolidays.png

Can you kindly advise?

Thanks, Jeff

Comments (4)

  1. jtabatabai reporter

    Thank you for the very prompt reply. I implemented the changes as suggested, however, when I pick a Date Discovered of July 3rd, the Due Date is resulting in July 4th.

    Here are screenshots of my configuration;

    Custom Schedule.png

    addTime.png

    Resulting Due Date.png

  2. Fidel Castro Armario repo owner

    It seems that there is little bug with whole day intervals. I will fix in next version.

    Anyway, there is a very simple workaround: simply add 1 day and 1 millisecond. Use the following formula:

    addTime({nnnnn}, 1 * {DAY} + 1, "Annual Holidays", LOCAL)
    
  3. Log in to comment