Page History
This Blueriq function lets you calculate a date in the future a certain number of working days away from a chosen start date. A similar function exists in the expression language: Date and Time functions#WORKINGDAYSBETWEEN. What we want to achieve with this new function is similar to Date and Time functions#ADDPERIODTODATE, but now with working days instead of all days. A typical use case is that you want to give an answer to a customer within X working days after the application is received. You want to add X working days to the current date, but there is no such function available in the expression language. For calculating this, you want to take weekends into account as well as holdays.
| Support Version | Download | ||||||
|---|---|---|---|---|---|---|---|
| >=11.2 |
|
Input and output parameters
| Parameter name | Direction | Valid | Meaning |
|---|---|---|---|
StartDate | Input | Any date | The date you want to start counting from |
NumberOfWorkingDays | Input | A number >=0 and <=100 | The number of working days that you want to add to the StartDate |
EndDate | Output | - | The date that is X NumberOfWorkingDays in the future |
In case you want to retrieve the list of the vacation days externally, a second function is present which has on additional paremter for setting these.
| Parameter name | Direction | Valid | Meaning |
|---|---|---|---|
VacationDays | Input | MultiValue Date | The date you want to start counting from |
Limitations in use
This function iterates through each date in the future until it finds a date which is the correct number of working days distanced. This means that it takes longer to compute the further away the date is. As most use cases concern numbers <=20, this should not be a problem. We want to discourage the use above 100 days due to performance reasons.
...
Overview
Content Tools