Why is the 'Get Business Days Between Dates for Location' step returning the wrong number?
I'm using the 'Get Business Days Between Dates for Location' step in Decisions to calculate business days between two dates, but the results seem off. For example, for March 2025 (no holidays), I expect 21 working days but get 20. For December 2025 (one holiday), I expect 22 but get 21. The "Include Start/End in Count" option doesn't seem to help. Is there another setting I should check?
Comments
-
Hello,
The 'Get Business Days Between Dates for Location' step calculates business days by excluding weekends and any holidays configured for the selected Location. Here’s what to check:
Resolution Steps:
- Make sure your Location entity has the correct working days (e.g., Mon-Fri) and all holidays manually added for each year.
- If a working day is missing or an extra holiday is set, the count will be off.
- The "Include Start/End in Count" option only includes those dates if they are business days.
Hope this helps!
Relevant Documentation:
Get Business Days Between Dates For Location Step
Configuring Locations and Holidays - https://documentation.decisions.com/docs/configuring-locations?highlight=locations-and-holidays
Howdy, Stranger!
Categories
- 4.5K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 112 Rules
- 277 Administration
- 215 Portal
- 502 General Q & A
- 721 Forms
- 355 Reports
- 3 Designer Extensions
- 47 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 189 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 72 Repository
- 237 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 26 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions