You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.

Tags

Interaction, Function

Type of accelerator

Accelerator to speed up development

How to get
CompatibilityBlueriq 11.2 and higher

Description

This Blueriq function lets you calculate a date in the future that is a certain number of business days ("working days") away from a given 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 holidays.

Input and output parameters

Parameter nameDirectionValidMeaning
StartDateInputAny dateThe date you want to start counting from
NumberOfWorkingDaysInputA number >=0 and <=100The number of working days that you want to add to the StartDate
EndDateOutput-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 one additional parameter for setting these.

Parameter nameDirectionValidMeaning
VacationDaysInputMultiValue DateThe 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.

Possibilities for customization or extensions

You can set which days in the week count as working days. Each workday is defined as static instance. For example:

Monday

and Saturday

For the numbering of days, see: Date and time functions#DAYOFWEEK

You can also set which days count as holidays. For this the static instance DutchVacationDays can be edited (and/or renamed).

It is no problem to add dates which are also on a non-working week day. By default, all vacation days of the second half of 2018, and of complete 2019 are added, and you extend this to the future as far as needed.

You could theoretically extend this function to also take vacations of specific employees into account. You would then need to add a new parameter with a user ID, and then add an additional check to the CheckDateValid flow. You would need to connect to a system which stores vacation days, and then add a similar check on a new condition node.

  • No labels