Next: , Previous: Time Extraction, Up: Time & Date



5.7.8.4 Functions that Produce Dates

These functions take numeric arguments and give numeric results that represent dates. Arguments taken by these functions are:

day
Refers to a day of the month between 1 and 31. Day 0 is also accepted and refers to the final day of the previous month. Days 29, 30, and 31 are accepted even in months that have fewer days and refer to a day near the beginning of the following month.
month
Refers to a month of the year between 1 and 12. Months 0 and 13 are also accepted and refer to the last month of the preceding year and the first month of the following year, respectively.
quarter
Refers to a quarter of the year between 1 and 4. The quarters of the year begin on the first day of months 1, 4, 7, and 10.
week
Refers to a week of the year between 1 and 53.
yday
Refers to a day of the year between 1 and 366.
year
Refers to a year, 1582 or greater. Years between 0 and 99 are treated according to the epoch set on SET EPOCH, by default beginning 69 years before the current date (see SET EPOCH).

If these functions' arguments are out-of-range, they are correctly normalized before conversion to date format. Non-integers are rounded toward zero.

— Function: DATE.DMY (day, month, year)
— Function: DATE.MDY (month, day, year)

Results in a date value corresponding to the midnight before day day of month month of year year.

— Function: DATE.MOYR (month, year)

Results in a date value corresponding to the midnight before the first day of month month of year year.

— Function: DATE.QYR (quarter, year)

Results in a date value corresponding to the midnight before the first day of quarter quarter of year year.

— Function: DATE.WKYR (week, year)

Results in a date value corresponding to the midnight before the first day of week week of year year.

— Function: DATE.YRDAY (year, yday)

Results in a date value corresponding to the day yday of year year.