where to find the ID of a holidays set
The number of working days tokens can be used to display the number of working days in a given month.
The structure of these tokens is:
[tWD:XXXXX:YYYYY]
where XXXXX is the Holidays Set ID of a holidays set containing national holidays, and YYYYY is the ID of another holidays set, this one containing regional holidays.
➢if there are no regional holidays, then the :YYYYY can be omitted.
The ID of a holidays set can be located in the holidays manager, as shown in the image on the right.
IMPORTANT: If the holidays sets XXXXX and YYYYY are used nowhere else in the script, then you must add these holidays sets to your list of included holidays, to ensure that holidays occurrences for these sets are available during diary generation.
The twd token produces different results, depending on whether each of the letters twd is uppercase or lowercase.
Workable Days
The central concept of working days tokens is the definition of workable days, from which various holidays are subtracted.
Workable days are defined as Monday to Friday, when using t, as the first letter of the token, or Monday to Saturday, when using T.
Variants
The variants of the tWD token are detailed below.
[tWD] [tWD0] [TWD] [TWD0] |
Number of workable days in the current month (Monday to Friday, when using t, or Monday to Saturday, when using T), minus the number of holidays of the holidays set XXXXX in that same month (ie. minus any workable day that is a national holiday). The variant token [tWD0] is the same as the token [tWD] with the difference that it is blank if its value is the same as for the token [twd] (ie. there are no holidays from the set YYYYY in the current month). |
|---|---|
[twd] [twd0] [Twd] [Twd0] |
Same as above, minus the number of holidays of the holidays set XXXXX or YYYYY in that same month (ie. minus any day that is a national or a regional holiday). The variant token [twd0] is the same as the token [twd] with the difference that it is blank if its value is the same as for the token [tWD] (ie. there are no holidays from the set YYYYY in the current month). |
Working Days Over Periods Other than a Month
By default, these tokens count the number of working days in the month of the token.
But, it is also possible to count working days over a different range of dates, using duration suffixes. For example, the token [1tWD:21588:22470:y+00] would count the number of working days for the entire year of the token's date.
See also: German working days in month, German Zinstage, Norwegian rente days.
Topic 183105, last updated on 13-Nov-2023
