Date Intervals, Formats, and Functions

Examples of Interval Specifications

Table 1 shows examples of different kinds of interval specifications.

Table 1: Examples of Intervals

Name Description of Interval
YEAR Years that start in January
YEAR.10 Years that start in October
YEAR2.7 Biennial intervals that start in July of even years
YEAR2.19 Biennial intervals that start in July of odd years
YEAR4.11 Four-year intervals that start in November of leap years (frequency of U.S. presidential elections)
YEAR4.35 Four-year intervals that start in November of even years between leap years (frequency of U.S. midterm elections)
YEARV Years that start on the Monday on or immediately preceding January 4th
YEARV.2 Years that start on the Monday immediately following January 4th
R445MON Months that start on the 1st, 5th, 9th, 14th, 18th, 22nd, 27th, 31st, 35th, 40th, 44th, and 48th Monday of the year. The 1st Monday is the Monday on or immediately preceding January 4th
R445MON3 Three-month intervals that start on the 1st, 14th, 27th, and 40th Monday of the year. This is equivalent to R445QTR
R445MON3.2 Three-month intervals that start on the 5th, 18th, 31th, and 44th Monday of the year. This is equivalent to R445QTR.2
WEEK Weekly intervals that start on Sundays
WEEK2 Biweekly intervals that start on first Sundays
WEEK1.1 Same as WEEK
WEEK.2 Weekly intervals that start on Mondays
WEEK6.3 Six-week intervals that start on first Tuesdays
WEEK6.11 Six-week intervals that start on second Wednesdays
WEEKDAY Daily with Friday-Saturday-Sunday counted as the same day (five-day work week with a Saturday-Sunday weekend)
WEEKDAY17W Same as WEEKDAY
WEEKDAY5.2 Five weekdays that start on Monday. If WEEKDAY data are accumulated into weekly data, the interval of the accumulated data is WEEKDAY5.2
WEEKDAY67W Daily with Thursday-Friday-Saturday counted as the same day (five-day work week with a Friday-Saturday weekend)
WEEKDAY1W Daily with Saturday-Sunday counted as the same day (six-day work week with a Sunday weekend)
WEEKDAY3.2 Three-weekday intervals (with Friday-Saturday-Sunday counted as one weekday) with the cycle three-weekday periods aligned to Monday, January 4, 1960
HOUR8.7 Eight-hour intervals that start at 6 a.m., 2 p.m., and 10 p.m. (might be used for work shifts)


Last updated: June 19, 2025