Dates
Date calculations are based on a "baseline" date, which is specified in the stream properties dialog box. 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. |