Calendars

The following syntax is used to generate a statement for each exported Calendar:

CREATE CALENDAR identifier.name 
   [DESC //description//] [MATCH {PREVIOUS|NEXT}] 
   WEEKENDN dayofweek  DFLTSEP(separator)  DFLTYEAR year
   MONTHS(shortmon1, longmon1,…shortmon12, longmon12)
   DATE(date) RULE(rule); 

Keywords

The keywords correspond to values that can be specified for a Calendar. For more information about an individual parameter, refer to Using the Editor.

CALENDAR
Specify the name of the Calendar.
name
Name of the Calendar.
DESC
Specify the description of the Calendar.
//description//
Text to describe the content or purpose of the Calendar (up to 40 characters).
MATCH
Specify the direction for adjusting calculated dates. This adjustment applies when you specify Closest in a Calendar Rule, and the days on either side of a calculated date are equal.
NEXT
Adjust the calculated date to the next day if needed.
PREVIOUS
Adjust the calculated date to the previous day if needed.
WEEKEND
Specify the day of week that represents a weekend in the calendar year.
N
Number (1 or 2) used to indicate the first or second weekend day.
dayofweek
The day of the week (e.g., Monday, Friday) that represents all or part of a standard weekend.
DFLTSEP
Specify the date separator to use in formatting dates.
(separator)
Date separator for formatting dates.
DFLTYEAR
Specify the default year.
yyyy
The default year in yyyy format.
MONTHS
Specify the names of the months defined in the Calendar.
shortmon
Abbreviated name for month.
longmon
Full name for a month.
DATE
Specify the unique names to describe the special days in a calendar year. Up to 14 names can be specified and each name may be specified as many times as required.

There must be a separate DATE entry for each instance defined to the calendar.

date
The name of the special day in the calendar year.
RULE
Enter the specifications for handling date aging to accommodate your unique requirements. Any number of rules may be specified.

There must be a separate RULE entry for each instance defined to the calendar.

rule
The Specifications for handing date aging to accommodate your requirements.

DATE

The following information is required for each DATE in the Calendar.

DATE (datename 
   [DESC //description//] DAY day WHICH {n|EVERY|LAST}
   OFFSET n  DURATION n  ABSORB {Y|N}
   RESOLVE {CLOSEST|PREVIOUS|NEXT|None}
   MONTH longmon YEAR nnnn 
   REOCCUR_ TYPE {DAY|WEEK|MONTH|YEAR|None}
   REOCCUR_ VALUE n REOCCUR_ ENDDATE mm/dd/yyyy)
DATE
Specify the name of the category to which the date applies.
datename
1 to 8 character name to describe the Calendar Date.
DESC
Specify text to describe or explain the Calendar Date delimited by double slashes.
//desc//
Text to describe the Calendar Date (up to 40 characters).
DAY
Enter the name of the day that identifies the Calendar Date.
day
The name of the day (e.g., Monday).
WHICH
Specify the instance that applies to the Calendar Date.
n
Enter the number associated with the DAY keyword.
EVERY
Indicates every instance of a specific day.
LAST
Indicates the last instance of a specific day.
OFFSET
Specify the number of days to adjust the Calendar Date.
+
Increment the Calendar Date by the number supplied.
Decrement the Calendar Date by the number supplied.
n
Number from 1 to 366 to adjust the Calendar Date.
DURATION
Specify the duration of the Calendar Date.
n
Number from 1 to 366 to specify the duration of the Calendar date.

The duration value entered must not cause any portion of the Calendar date to occur in a different year.

ABSORB
Indicate whether to mark an additional day as a holiday if the date falls on a Tuesday or a Thursday.
Y
Mark an additional day as a holiday.
N
Do not mark an additional day as a holiday.
RESOLVE
Indicate how to resolve a Calendar Date if it occurs on a weekend or holiday.
None
Do not resolve the Calendar Date.
CLOSEST
The closest workday.
NEXT
The next workday.
PREVIOUS
The previous workday
MONTH
Specify the month to start using the Reoccurs (frequency) settings for a Calendar Date.
longmon
The month to start using the Reoccurs (e.g., JAN).
YEAR
Specify the year to start using the Reoccurs (frequency) settings for the Calendar Date.
yyyy
The year in yyyy format.
REOCCUR_TYPE
Specify the frequency of the Calendar Date. (For example, in some organizations, payday is every two weeks regardless of the date.)
None
The date does not reoccur.
DAY
The date reoccurs every nth day.
WEEK
The date reoccurs every nth week.
MONTH
The date reoccurs every nth month.
YEAR
The date reoccurs every nth year.
REOCCUR_VALUE
Specify the nth unit of time specified in the REOCCUR_TYPE keyword.

You can specify a value only when REOCCUR_TYPE keyword is not “(None)”.

n
Number for the nth unit of time.
REOCCUR_ENDDATE
Specify the date the frequency specifications are to be discontinued.

You can specify a value only when REOCCUR_TYPE keyword is not “(None)”.

mm/dd/yyyy
Date to discontinue using the frequency specifications.

RULE

The following information is required for each RULE in the Calendar.

RULE rulename 
   [DESC //description//] AVOIDDATES(date1, date2, … daten)
   SEARCHDATES(date1, date2, … daten)
   ADJUSTMENT{CLOSEST|PREVIOUS|NEXT};
RULE
Specify the name of the Calendar Rule you want to define.
rulename
The Calendar Rule name.
DESC
Enter the text to describe the type of date you are defining.
//description//
1 to 40 character description of the type of date you are defining.
AVOIDDATES
Specify the Calendar Date to avoid when making an adjustment.
daten
The date type you defined by the DATE keyword or one of the sample date types provided with the Calendar Utility.
SEARCHDATES
Specify the Calendar Dates to search for when making an adjustment.
daten
The date type you defined by the DATE keyword or one of the sample date types provided with the Calendar Utility.
ADJUSTMENT
Direction to adjust an aged date if it does not satisfy the Avoid or Search Specifications.
CLOSEST
The closest day.
NEXT
The next day.
PREVIOUS
The previous day