Business days excluding public holidays and weekends
It would be great to be able to calculate business (working) days, i.e. excluding weekends and public holidays, between two dates. Ideally, one of it would be <Today>. Thanks.
Thanks for your suggestion. We definitely see the value in calculating the number of business days excluding weeekends and public holidays. The challenge is knowing where public holidays are based on your region (which can change quite a bit depending on location).
This would require either Nintex maintaining a global list of public holidays which is a high overhead, or the form designer maintaining a list of public holidays within their platform.
What would you see is an appropriate solution? Let us know in the comments section below.
I think it'd make sense for the form designer to configure/manage this for the following two reasons:
- This will allow for individual unique scenarios, e.g. a specific team that is on call for whom certain public holidays might not apply, therefore the config is unique even within a region.
- Hopefully, it will allow Nintex to roll these feature out sooner rather than later...I can imagine the overhead it will cause for Nintex trying to maintain a global list. Besides, there is no clear guidance even within a country, it can change by cities, i.e. a holiday confined to a specific city within a country, e.g. Auckland anniversary day which is only applicable to Auckland and each city within New Zealand having their respective anniversary days.