0 / 0
Dates (SPSS Modeler)

Dates

Date calculations are based on a "baseline" date, which is specified in the flow properties. The default baseline date is 1 January 1900.

The CLEM language supports the following date formats.

Table 1. CLEM language date formats
Format Examples
DDMMYY 150163
MMDDYY 011563
YYMMDD 630115
YYYYMMDD 19630115
YYYYDDD Four-digit year followed by a three-digit number representing the day of the year—for example, 2000032 represents the 32nd day of 2000, or 1 February 2000.
DAY Day of the week in the current locale—for example, Monday, Tuesday, ..., in English.
MONTH Month in the current locale—for example, January, February, ….
DD/MM/YY 15/01/63
DD/MM/YYYY 15/01/1963
MM/DD/YY 01/15/63
MM/DD/YYYY 01/15/1963
DD-MM-YY 15-01-63
DD-MM-YYYY 15-01-1963
MM-DD-YY 01-15-63
MM-DD-YYYY 01-15-1963
DD.MM.YY 15.01.63
DD.MM.YYYY 15.01.1963
MM.DD.YY 01.15.63
MM.DD.YYYY 01.15.1963
DD-MON-YY 15-JAN-63, 15-jan-63, 15-Jan-63
DD/MON/YY 15/JAN/63, 15/jan/63, 15/Jan/63
DD.MON.YY 15.JAN.63, 15.jan.63, 15.Jan.63
DD-MON-YYYY 15-JAN-1963, 15-jan-1963, 15-Jan-1963
DD/MON/YYYY 15/JAN/1963, 15/jan/1963, 15/Jan/1963
DD.MON.YYYY 15.JAN.1963, 15.jan.1963, 15.Jan.1963
MON YYYY Jan 2004
q Q YYYY Date represented as a digit (1–4) representing the quarter followed by the letter Q and a four-digit year—for example, 25 December 2004 would be represented as 4 Q 2004.
ww WK YYYY Two-digit number representing the week of the year followed by the letters WK and then a four-digit year. The week of the year is calculated assuming that the first day of the week is Monday and there is at least one day in the first week.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more