Last updated: Jan 17, 2024
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.
| 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. |