Best Practices Guide > Useful Calendar Keywords

Useful Calendar Keywords

Even if a company uses many company-specific calendar dates, there are some dates which are generally helpful. The following Calendar object provides a collection of typical calendar keywords which can be useful when processing tasks.

Weekly

Name	Description
MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY	Each individual day of the week is stored as an individual calendar keyword.
WEEKDAYS_MON_TO_FRI	Contains all Mondays, Tuesdays, Wednesdays, Thursdays and Fridays
WEEKEND	Contains all Saturdays and Sundays

Monthly

Name	Description
FIRST_DAY_OF_MONTH	Contains the first day of a month Select day "1" in the calendar definition and the option Count the days from the beginning of the month.
LAST_DAY_OF_MONTH	Contains the last day of a month Select day "2" in the calendar definition and the option Count the days from the end of the month.

Name

Description

FIRST_DAY_OF_MONTH

Contains the first day of a month

Select day "1" in the calendar definition and the option Count the days from the beginning of the month.

LAST_DAY_OF_MONTH

Contains the last day of a month

Select day "2" in the calendar definition and the option Count the days from the end of the month.

Yearly

Name	Description
QUARTER_1, QUARTER_2, QUARTER_3, QUARTER_4	There is a calendar keyword for each quarter. Select In a defined interval in the calendar definition and specify the quarter's start and end date (e.g.: 01.01. until 31.03).

Name

Description

QUARTER_1, QUARTER_2, QUARTER_3, QUARTER_4

There is a calendar keyword for each quarter.

Select In a defined interval in the calendar definition and specify the quarter's start and end date (e.g.: 01.01. until 31.03).

Group

Name	Description
WORKDAYS	Contains all weekdays from Monday to Friday except holidays Select the calendar keyword WEEKDAYS_MON_TO_FRI in the calendar definition. Enter the holiday calendar of your country (e.g. UC_HOLIDAYS.US with the keyword TOTAL) in the setting AND none of the following Calendars apply.

Name

Description

WORKDAYS

Contains all weekdays from Monday to Friday except holidays

Select the calendar keyword WEEKDAYS_MON_TO_FRI in the calendar definition. Enter the holiday calendar of your country (e.g. UC_HOLIDAYS.US with the keyword TOTAL) in the setting AND none of the following Calendars apply.

Roll

Name	Description
FIRST_WORKDAY_OF_MONTH	Contains the first workday of each month Select the source calendar keyword LAST_DAY_OF_MONTH. Select adjust by "+1" day. Specify the calendar keyword WORKDAYS for the option use valid days from.
LAST_WORKDAY_OF_MONTH	Contains the last workday of each month Select the source calendar keyword FIRST_DAY_OF_MONTH. Select adjust by "-1". Specify the calendar keyword "WORKDAYS" for the option use valid days from.

Name

Description

FIRST_WORKDAY_OF_MONTH

Contains the first workday of each month

Select the source calendar keyword LAST_DAY_OF_MONTH. Select adjust by "+1" day. Specify the calendar keyword WORKDAYS for the option use valid days from.

LAST_WORKDAY_OF_MONTH

Contains the last workday of each month

Select the source calendar keyword FIRST_DAY_OF_MONTH. Select adjust by "-1". Specify the calendar keyword "WORKDAYS" for the option use valid days from.