day-date

Description

The day-date placeholder identifies a day or group of days.

Syntax

day-date::=

weekday-expr | relative-weekday-expr | 
day n { each month | each quarter | each year } | year/month/day | month/day |
month/day each quarter

weekday-expr::=

[ weekday-name | weekday-aggregate | weekday-range ]...

weekday-name::=

mon•day[s] | tue•sday[s] | wed•nesday[s] | thu•rsday[s] | fri•day[s] |
sat•urday[s] | sun•day[s]

weekday-aggregate::=

daily | weekend[s] | weekday[s]

weekday-range::=

weekday-name-weekday-name

relative-weekday-expr::=

[ weekday-ordinal weekday-name ]... |
[ { weekday_name }... except weekday-ordinal ]... |
[ { weekday_name }... [ except ] { before | after } weekday-ordinal weekday-name ]...

weekday-ordinal::=

first | second | third | fourth | fifth | last

Semantics

weekday-expr

Identifies one or more weekdays independently of where they occur in a month. Weekday ranges must run from earlier to later in the week. For example, Sunday-Friday is permitted but not Thursday-Tuesday.

relative-weekday-expr

Identifies one or more weekdays based on where they occur in a month.

weekday-ordinal weekday-name

Identifies weekdays by the order in which they occur in the month.

weekday-name except weekday-ordinal

Identifies weekdays by name, but excludes those that fall within the specified order.

day-of-week [ except ] { before | after } weekday-ordinal weekday-name

Identifies specific weekdays that fall before or after another day, or weekdays except those that fall before or after another day.

day n each { month | quarter | year }

Identifies the nth ordinal day of each month, quarter, or year. There are 92 days in a quarter; day 92 is considered last even if there are fewer days in the quarter..

year/month/day

Identifies the specified day only once.

month/day

Identifies the specified day every year.

month/day each quarter

Identifies the day of the given relative month (1, 2, or 3) in every calendar quarter.

Example

Sample values include the following:

daily
Monday-Thursday Saturday
Wednesday weekends
last Saturday
second Thursday third Sunday
Thursday Friday Saturday except first
Saturday except third
Saturday Sunday after first Friday
weekdays before last Saturday
weekends except after last friday
monday wednesday except before first sunday
day 4 each month
day 31 each quarter
day 90 each year
2005/12/25
12/25
3/1 each quarter