Next: , Previous: , Up: Time & Date Functions   [Contents][Index]


7.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.


Next: Functions that Examine Dates, Previous: Functions that Examine Times, Up: Time & Date Functions   [Contents][Index]