Dates Tab

You can define and name up to 14 unique categories to describe special Calendar dates, such as holiday, payday, quarter, etc. Each name may be specified as many times as required to identify the special day. (For example, in the distributed US Calendar, there are 8 days predefined as HOLIDAY.)

Select the Dates tab on the Calendar Editor to:

Grid Details

Name
A category to which the Calendar date applies (1 to 8 characters).
  • You can specify up to 14 unique names.
  • You can use the same name, with different characteristics, any number of times.
Description
Text to describe or explain the Calendar date (up to 40 characters).
Date/Day
A name to identify the day for the Calendar date. Click the down arrow to select from a list of the following:
  • Day of the week
  • Easter
  • Workday
  • Day of the Month
Date/Which
The frequency of the Date/Day you enter. To select from a list of valid entries, click to display a down arrow, then click the down arrow. For example:
If you enter Date/Day:
Specify:
Day of the week
Every Week, Week 1, Week 2, Week 3, Week 4, or Last Week
Workday
Every, an explicit day by number 1 through 25, or Last
Day of the Month
Every, an explicit day by number 1 through 31, or Last
Easter
No entry required.
Note:
  • Every indicates every instance of the specific day, for recurring dates.
  • Last indicates the last instance of the specific day.
  • Workday indicates any day not specifically defined as a Weekend or Holiday.
  • Easter calculates the specific day based on Easter Sunday, using a plus (+) or minus (-) offset
.
Date/Offset
The number of days (1 to 366) to adjust the Calendar date. Use a minus (-) sign to decrement the date, or a plus (+) sign to increment the date.
Note: The Date/Offset value entered must not cause the adjusted date to occur in a different year. The value you specify must be less than or equal to the number of days remaining in the year (if incremental), or the number of days since the beginning of the year (if decremented).
Date/Duration
The duration of the Calendar date, in number of days (1 to 366).
Note: The Date/Duration value entered must not cause any portion of the Calendar date to occur in a different year. The value you specify must be less than or equal to the number of days remaining in the year (if incremental), or the number of days since the beginning of the year (if decremented).

Scroll the grid horizontally to the right to display the following details:

calendar editor dates tab, explained below
Absorb Contig
Select this check box to include Monday when the specified Calendar date occurs on a Tuesday, or to include Friday when the specified Calendar date occurs on a Thursday. The check box is cleared by default.
Resolve Weekend/Holiday
The adjustment parameter to use when the Calendar date occurs on a weekend or holiday. Specify None if no adjustment is required. Click the down arrow to select from the following list:
  • None
  • Closest Workday
  • Previous Workday
  • Next Workday
Start/Month
The month to start using the Reoccurs (frequency) settings for the Calendar date.
Start/Year
The year to start using the Reoccurs (frequency) settings for the Calendar date.
Reoccurs/Type
The frequency of the Calendar date. (For example, payday may occur every two weeks, regardless of the date.) Click the down arrow to select from a list, where n is the number for each unit of time. “(None)” indicates the Calendar date does not reoccur.
Reoccurs/ Value
The number for the nth unit of time specified in the Type of frequency. You can specify a value only when Type is not “(None)”.
Reoccurs/ Ending Date
The date that the frequency specifications are to be discontinued. You can specify a value only when Type is not “(None)”. The default ending date is 12/31/3999.

For a list of sample Calendar dates provided with Optim™, see Sample Calendar Dates.