In some script statements and script functions, formats for date, time and periods can be specified. The following tables list all possible formats.
[Date Formats] [Time Formats] [Period Formats]
Date format abbreviations are "Y" or "J" for the year, "M" for the month and "D" or "T" for the day.
|
Date Format |
Example |
|---|---|
|
YYMMDD or JJMMTT |
001231 |
|
YY.MM.DD or JJ.MM.TT |
00.12.31 |
|
YY-MM-DD or JJ-MM-TT |
00-12-31 |
|
YYYYMMDD or JJJJMMTT |
20001231 |
|
YYYY.MM.DD or JJJJ.MM.TT |
2000.12.31 |
|
YYYY-MM-DD or JJJJ-MM-TT |
2000-12-31 |
|
DDMMYY or TTMMJJ |
311200 |
|
DD.MM.YY or TT.MM.JJ |
31.12.00 |
|
DD-MM-YY or TT-MM-JJ |
31-12-00 |
| DDMMYYYY or TTMMJJJJ | 31122000 |
| DD.MM.YYYY or TT.MM.JJJJ | 31.12.2000 |
| DD-MM-YYYY or TT-MM-JJJJ | 31-12-2000 |
| MMDDYY | 123100 |
| MMDDYYYY | 12312000 |
| MM/DD/YY | 12/31/00 |
|
MM/DD/YYYY |
12/31/2000 |
The specification of special terms is possible in date formats. Two special terms are "WW" and "LLL".
"WW" corresponds to the day of the week as a two-digit German abbreviation as shown below:
- MO: Monday
- DI: Tuesday
- MI: Wednesday
- DO: Thursday
- FR: Friday
- SA: Saturday
- SO: Sunday
"LLL" corresponds to the running day of the year.
The use of special terms for date formats is not allowed with script functions which calculate with dates. An exception is the output format of a determined date.
|
Date Format (Special Terms) |
Example |
|---|---|
|
YY or JJ |
99 |
|
YYYY or JJJJ |
1999 |
|
MM |
12 |
|
DD or TT |
31 |
|
WW |
FR |
|
LLL |
365 |
[Date Formats] [Time Formats] [Period Formats]
Time format abbreviations are "H" for hours, "M" for minutes and "S" for seconds.
|
Time Format |
Example |
|---|---|
|
HHMMSS |
235959 |
|
HH:MM:SS |
23:59:59 |
|
HHMM |
2359 |
|
HH:MM |
23:59 |
|
MMSS |
5959 |
|
MM:SS |
59:59 |
|
Time Format (Special Terms) |
Example |
|---|---|
|
HH |
23 |
|
MM |
59 |
|
SS |
59 |
[Date Format] [Time Format] [Period Format]
The following abbreviations are used for period formats: "J" or "Y" for the year, "Q" for the quarter, "M" for the month and "W" for the calendar week.
The following period formats can be used in the script elements FIRST_OF_PERIOD, LAST_OF_PERIOD, ADD_PERIOD, SUB_PERIOD.
|
Period Format |
Example |
|---|---|
|
YY or JJ |
00 |
|
YYYY or JJJJ |
2000 |
|
Q |
3 |
|
MM |
06 |
|
WW |
53 |
|
WS * |
53 |
* The period format "WS" can only be used in the script functions for determining the first or the last day of the period. For this period format, Sunday applies as the first day of the week. "WW" on the other hand, takes its starting day on Monday.