Calendars, Schedules, Tasks, and Triggers › Calendars › The Advanced Calendar Designer › Calendar Rule Logical Operators

Calendar Rule Logical Operators

Use the four logical set operators to include and exclude dates in calendar rules. The Union, Intersection, and Exclusion operators provide a way to include and exclude dates represented by basic date conditions or by branching combinations of conditions and operators. The following list describes each logical operator:

Union

Indicates that one or more of the linked conditions must be satisfied for the combined condition to be satisfied.

Place one or more branches or basic conditions under this icon.

Intersection

Indicates that the linked conditions must all be satisfied for the combined condition to be satisfied.

Place one or more branches or basic conditions under this icon.

Exclusion

Indicates a basic condition or a branch to be excluded from a rule.

All dates are excluded that are not otherwise selected. It is therefore only useful to exclude days when they are selected by another part of the rule. For example, no purpose is served by excluding Tuesdays unless they are defined as valid days by other conditions and operators in a rule. So if a condition specifies the work week (Monday through Friday) as valid days, you could use the Exclusion operator to exclude Tuesdays from this set.

Expand the Exclusion operator to show the Included and Excluded branches.

Click a branch and then add a condition or operator to define included or excluded dates.This operator has two sets of branched arguments:

Included: One or more basic conditions or branches that represent dates to be included in the rule.

Excluded: One or more basic conditions or branches representing dates to be excluded from the dates defined by the Included set.

Like

Use the Like operator to use an existing set of dates defined by another calendar object in your rule. This operator has the following parameters:

Calendar Name: The name of the referenced calendar.

Delta: Shifts the valid dates defined by the referenced Calendar by the specified number of days. Enter a negative number to move the dates earlier, or a positive number to move the dates later.

Open Days: When checked, indicates that the delta or shift only applies to open days.

For example, a new calendar rule could reference another calendar specifying backup days with a delta of 1. The resulting condition in the new calendar rule specifies the day immediately following backup days.