skr35
Scholar

Calculate a task due date to business days only

Jump to solution

I'm posting my solution for this common issue here in the hopes to help other users who have similar requirements to assign Flexi-tasks to users on Business Days only. I had seen on nintex community that there was a UDA created for this but it didn't work properly for me (due dates were just blank). I am using SharePoint 2013.

Here is my manual workaround that has been working very well for my workflow:

 

 
  1. Query List Action - this is used to query a list we have on our site where the number of days to complete a task is stored. This is used to find the appropriate number of days given certain conditions but if your days are standard for all tasks this is not necessary. Output is a number variable, varDaystoAdd
  2. Calculate Date Action - adds varDaystoAdd to current date and stores in date variable, varDueDate
  3. Set Variable Action - finds the day of the week varDueDate is: 
    1. use function:  fn-FormatDate(varDueDate, "dddd") store in varDay
    2. "dddd" will output the day of the week written out ex) "Friday", "Saturday" or "Sunday"
  4. Log day - i used this just to record varDay for troubleshooting purposes
  5. Conditional Statement - is varDay = value of Saturday?
    1. If Yes, add 2 days to due date
      1. Date is varDueDate, put value of 2 in Days field and store again in varDueDate
      2. If No, nothing happens
  6. Conditional Statement - is varDay = value of Sunday?
    1. If Yes, add 1 day to due date
      1. Date is varDueDate, put value of 1 in Days field and store again in varDueDate

 

 

I hope this is helpful, please put any questions or comments below

skr35_1-1650469317839.png

Reply
2 Replies
MillaZ
Community Manager
Community Manager

Re: Calculate a task due date to business days only

Jump to solution

Thank you Sophia! 

I am just going to mark this reply as solved so others can view the info. 

0 Kudos
Reply
rtsp94
Scholar

Re: Calculate a task due date to business days only

Jump to solution

Thank you so much for this, it took me awhile to locate this thread/solution.  This really saved me some time and pain .  Also, building on your solution, I added a additional block of Actions after your solution that performs a query list a SharePoint list of holidays (in my case, federal holidays) up to four years worth and add the holiday dates to a collection and from that collection I check to see if that due date Exist in the collection, if True I add a additional day to the due date.

 

rtsp94_0-1652290728961.png

 

0 Kudos
Reply