Date Construction (PSPP)

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.