Date, Time and Period Formats

In some script statements and script functions, formats for date, time and periods can be specified. The following tables list all possible formats.

Date Format

[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:

"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

Time Formats

[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

Period Formats

[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.