Previous Topic: Calendar Rule Logical OperatorsNext Topic: Add and Remove Calendar Dates Manually


Calendar Rule Date Operators

This section describes the elementary conditions on dates and their parameters. The conditions can be placed in the rule pane of the Calendar Designer. To select a date in any operator's properties, click the calendar icon to open the calendar viewer and select a date.

Dates List icon Dates List

Specifies individual dates. For example:

Parameters
Date Interval icon Date Interval

Specifies a regular daily, weekly, or monthly interval in a range of dates from beginning to end.

For example, every week from March 1, 2015 to July 1, 2016.

Parameters
Date Without Year List icon Date Without Year List

Specifies a list of explicit anniversary dates.

This condition is commonly used to specify holidays that fall on the same day every year. Examples include January 1st and December 25th.

Parameters
Date Without Year Interval icon Date Without Year Interval

Specifies an anniversary interval of dates without a year.

For example, from March 21st to June 20th (for Spring).

Parameters
Year Interval icon Year Interval

Specifies an interval of years.

You can specify leap years by starting an interval on a leap year and specifying a step of 4 (such as 2000 to 2024 with a step of 4).

Parameters
Month Interval icon Month Interval

Specifies one or more months in the year.

The first semester is specified with a range from 1 to 6 with a step of 1. The second semester is specified with a range from 7 to 12 with a step of 1.

Parameters
Week of the Month Interval icon Week of the Month Interval

Specifies one or more weeks in the month.

CA Process Automation implements ISO standards for partial weeks. A week which intersects with a given month is considered to be part of the month if the Thursday of that week falls in the month.

For example, if June 1st is a Friday, the First week of the month starts on June 4th. If June 1st is a Wednesday, the first week of the month starts on May 30th.

It is possible to have the “first Monday of the month” not be “Monday of the first week of the month.” To define the former, it is simpler to combine “Day of the month” and “Day of the Week” conditions.

Parameters

Beginning: The starting week for the interval.

End: The ending week for the interval.

Step: The number of weeks from one valid week to the next valid week.

Reverse: Counting starts with the last week of the month and goes backwards.

Week of the Year Interval icon Week of the Year Interval

Specifies one or more weeks in the year.

CA Process Automation implement ISO standards for partial weeks. A week which intersects with a given year is considered to be part of the year if the Thursday of that week falls in the year.

For example, if January 1st is a Friday, the First week of the year starts on January 4th. If January 1st is a Wednesday, the first week of the year starts on December 30th of the previous year.

It is therefore possible to have the “first Monday of the year” not be “Monday of the first week of the year.” To define the former, it is simpler to combine “Day of the year” and “Day of the Week” conditions.

Parameters

Beginning: The starting week for the interval.

End: The ending week for the interval.

Step: The number of weeks from one valid week to the next valid week.

Reverse: Counting starts with the last week of the year and goes backwards.

Day Interval icon Day Interval

Specifies an interval of valid days (between 1 to 31) in a month with a starting day, an ending day, and a step.

You can also specify that the iteration start from the end of the month or that only open days are counted in each step. Open days are those days not specified by a condition or rule that closes or excludes dates.

For example, the last day of the month is specified by the interval beginning and ending with 1 with Reverse selected. The last weekday of the month would be specified when the Open check box is also selected and a Weekday Interval specifying Monday through Friday is added with an And operator.

Parameters

Beginning: The starting day for the interval.

End: The ending day for the interval.

Step: The number of days from one valid day to the next valid day.

Reverse: Counting in steps starts with the last day of the month and goes backwards.

Open Days: Counting in steps includes only open days when days are closed by a condition or rule.

Day of the Year Interval icon Day of the Year Interval

Specifies an interval of valid days (between 1 and 366) in a year with a starting day, an ending day, and a step. The day 366 is valid on leap years.

You can also specify that the iteration start from the end of the year or that only open days are counted in each step. Open days are those days not specified by a condition or rule that closes or excludes dates.

For example, you can specify winter as the interval from December 21st to March 20th.

Or for a slightly more complicated example, to specify every 10th day throughout the entire year, you could use a range from 1 to 365 (or 366 for a leap) with a step of 1. You could specify the last ten open days of the year with a starting day of 1, an ending day of 10, with Reverse and Open selected.

Parameters

Beginning: The starting day for the interval.

End: The ending day for the interval.

Step: The number of days from one valid day to the next valid day.

Reverse: Counting in steps starts with the last day of the year and goes backwards.

Open: Counting in steps includes only open days.

Day of the Week Interval icon Day of the Week Interval

Specifies one or more days of the week (from Monday through Sunday) as an interval with a starting day, an ending day, and a step.

For example, weekends are specified by the interval beginning on Saturday and ending on Sunday with a step of 1.

Parameters

Beginning: The starting day for the interval

End: The ending day for the interval.

Step: The number of days from one valid day to the next valid day.

Weekday of the Month icon Weekday of the Month

Specifies a weekday in an indexed week of a particular month. The week is indexed from either the beginning or the end of the month.

Parameters

Weekday: Specifies the day of the week.

Month: Specifies the month for which the week day is applicable.

Week Index: Specifies the index of the week for which the week day would be applicable. (Value can be 1 to 5 because in any month there cannot be more than 5 weeks)

Reverse: If you select this check box, the counting for the week index starts from the last week.

For example, if you select Monday as a weekday, September as a month, and 3 as a Week Index: in September, the third Monday is included in the calendar. If you selected the reverse check box, in September, the third Monday from the last is included in the calendar.

Weekday of the Year icon Weekday of the Year

Specifies a weekday in an indexed week of the year. The week is indexed from either the beginning or the end of the year.

Parameters

Weekday: Specifies the day of the week.

Week Index: Specifies the index of the week for which the week day is applicable. (Value can be 1 to 53 because in a year there cannot be more than 53 weeks)

Reverse: If you select this check box, the week index counting starts from the last week.

For example, if you select Monday as a weekday, 43 as the Week Index, the forty third Monday of the year is included in the calendar. If you selected the reverse check box then the forty third Monday from the last week is included in the calendar.