Inline Function or Action to Calculate Business Days/Hours
There are many scenarios when you need to take into account business days/hours for a workflow. One example would be setting a due date for something, and only wanting to do it based on business days. There is currently not an easy way to do this. It would be great if there were either an inline function or a workflow action that allowed you to calculate a date and factor in business days/hours and even holidays.
Hey all,
There looks to be 2 requests here
- Update Inline function to allow calculate date difference, factoring in only business days / hours
- Update Calculate date action to factor in only business days / hours
Can you please share which of the two you require and your use cases
Thanks
Lisa
-
Mark Powley
commented
We actually use Excel Services in a leave request solution to provide a calculation of start date > end date, minus bank holidays (stored in a second worksheet) and then only return working business days using the inbuilt Excel formula. We have a different bank holiday worksheet per location and named cells populated by a switch in the workflow based on the user profile location information.
-
Nicole (Prestby) Vesser
commented
I get this request very frequently from clients and prospective clients looking to purchase Nintex. I agree with Linda's comment: "It would great if Nintex could enhance the "Calculate Date" action to include business days as an option. Similar to what they have done to task reminders. Task reminders provides the ability to select business days."
-
Daniel
commented
Can we get this implemented soon? I've only been using NWF for a month, but this is by far the biggest issue I have.
-
Linda Her
commented
It would great if NIntex could enhance the "Calculate Date" action to include business days as an option. Similar to what they have done to task reminders. Task reminders provides the ability to select business days.
-
Kyle
commented
This is sorely needed. I am using a lengthy user defined action in a separate workflow to plug days into. I would also like something that would remove working days from a date range to help calculate the task duration without including Weekends and holidays. This does not seem like it would be that difficult programmatically for nintex to pull off.
-
Brendan Murphy commented
Thanks for the suggestion Alexey, that sounds like a decent workaround until a better solution is created. Would you happen to have some instructions on how to do that?
-
Alexey Krasheninnikov commented
At the same time, Excel workbook would have no knowledge of the Nintex workdays, so the request is still valid.
-
You can do this with an Excel workbook published with WORKDAYS(.INTL) function and a WebRequest to make a parameterized query against it via Excel REST API.