+/- Working days (Integration function)

The function +/- Working days (Integration function) calculates a target date based on a given source date, modified by an integer number of working days earlier or later, which is returned as the result.

images/download/attachments/201673960/image2020-10-8_13-27-53-version-1-modificationdate-1747043859308-api-v2.png

The calculation applies the following principles:

  • Sundays are generally considered non-working days.

  • Parameter d defines globally whether Saturdays should be considered as a non-working day (false, default) or as a working day (true).

  • Whether the source date (parameter a) is a working day or not has no influence on the calculation.

  • Parameter b (+ or - sign) and parameter c (number of working days) determine the desired time offset.

    • With a time offset of 0 working days, the source date is taken directly as the target date. It is then possibly not a working day.

  • The time components in the source date are transferred directly to the target date.

    • If Daylight Saving Time (DST) begins or ends between the source date and the target date, the resulting time span is not an integer multiple of 24 hours.

Filter parameter

Parameter

Description

Example

Note

a

The source date entity, of which days are to be added or deducted from.

Result of function date(a)


b

+ to add days, - to deduct days.

+

-

If a different operation displays as + or -, then the value a is returned unchanged.

c

The number of working days from the source date

14

If a value smaller or equal to 0 is entered, then the value a is returned unchanged.

d

With the value true all Saturdays are considered as working days, otherwise Saturdays are considered non-working days.

true

false

If a value other than true or false is displayed, it is automatically set to false (Saturday is a non-working day).

Example

The target structure of a profile, which is executed when a new user account is created, defines a message for a third-party system, which is to be given not only the creation time (create_date) but also an appointment for an alarm (reminder).

The alarm should be dated with an offset of 10 working days after the creation of the user account:

images/download/attachments/201673960/image2020-10-8_13-30-35-version-1-modificationdate-1747043859310-api-v2.png

  • Parameter a refers to the target field create_date, to which a date value must be assigned.

  • Parameter b and parameter c define the time offset of 10 working days after this date.

  • Parameter d specifies that Saturdays are to be considered work-free.


Runtime example:

  • A user account will be created on Sunday, 03.01.2021 at 22:34:12.

  • As an alarm time, the field reminder is assigned Friday, 15.01.2021, at 22:34:12.