Please enable JavaScript to view this site.

 

Navigation: Tokens > Day Tokens

German Working Days in Month

Scroll Prev Up Next More

There are 3 types of daily tokens which can be used to display the number of working days (Arbeitstage) in Germany in a given month.

 

[tAT]

18 à 23

Number of working days (Monday to Friday) in the current month, minus the number of national German public holidays in that same month.

[tAt]

[tAt0]

18 à 23

Same as above, minus the number of regional public holidays observed by at least one German state (Land) in that same month.

 

The variant token [tAt0] is the same as the token [tAt] with the difference that it is blank if its value is the same as for the token [tAT] (ie. there are no regional holidays in the current month).

[tat]

[tat0]

18 à 23

Same as above minus the occurrence of the Peace Day (Friedensfest) municipal public holiday in Augsburg.

 

The variant token [tat0] is the same as the token [tat] with the difference that it is blank if its value is the same as for the token [tAt] (ie. there is no occurrence of the Peace Day (Friedensfest) Augsburg municipal public holiday in the current month).

 

Where does the holidays information come from?

 

the text file Q++Data.ini

the text file Q++Data.ini

These tokens are converted using:

 

2 holidays sets (national and regional) IDs and

2 individual holidays (that of the recurrence rule for the Friedensfest municipal public holiday in Augsburg, and, much more rarely, that of the Allerheiligen, All Saints' Day regional public holiday of Germany).

 

These set IDs and holiday IDs are specified in the [International] section of the ini file below, as detailed in the image on the right.

 

 Q:\Q++ServerXV4\UserFiles\Q++Data.ini

 

You can obtain the holidays set ID and specific holiday ID needed to fill that ini file, from the holidays manager, as shown below.

 

where to find the ID of a holidays set

where to find the ID of a holidays set

where to find the ID of a specific holiday

where to find the ID of a specific holiday

 

Some remarks about that ini file.

 

Do not forget to include the [International] section header in the ini file.

If you want to use Friedensfest but not Allerheiligen in your calculations of the token [tat], as will often be the case, then simply set the value of AT_Allerhligen in the ini file to 0.

 

IMPORTANT: after making any changes to the ini file above, you will need to close and start Q++Studio again, as this ini file is only read once, when Q++Studio starts.

 

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 [1tAT:y+00] would count the number of working days for the entire year of the token's date.

 

See also: German Zinstage, Norwegian rente days, working days.