Useful Calendar Events
Even if your company uses many company-specific calendar dates, some are generally helpful when processing tasks. These tables list the most important ones and describe their attributes.
Weekly
-
MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY
Each individual day of the week is stored as an individual calendar event
-
WEEKDAYS_MON_TO_FRI
Contains all Mondays, Tuesdays, Wednesdays, Thursdays and Fridays
-
WEEKEND
Contains all Saturdays and Sundays
Monthly
-
FIRST_DAY_OF_MONTH
Contains the first day of a month
Select day 1 in the calendar definition and the option Count from: Beginning of month.
-
LAST_DAY_OF_MONTH
Contains the last day of a month
Select day 2 in the calendar definition and the option Count from: End of month.
Yearly
QUARTER_1, QUARTER_2, QUARTER_3, QUARTER_4
There is a calendar event for each quarter.
Select Happening On: Defined days in the calendar definition and specify the quarter's start and end date (e.g.: 01.01. until 31.03).
Group
WORKDAYS
Contains all weekdays from Monday to Friday except holidays.
Select the WEEKDAYS_MON_TO_FRI calendar event in the calendar definition and combine it with the holiday calendar of your country.
Offset
-
FIRST_WORKDAY_OF_MONTH
Contains the first workday of each month.
Select LAST_DAY_OF_MONTH as existing event and define a matching offset event. Specify the WORKDAYS calendar event as target event and select Match to nearest target date: after or on .... Enter 1as additional offset.
-
LAST_WORKDAY_OF_MONTH
See Example 3 on Examples of Calendar Events.
See also: