Formatting Patterns

This page deals with the common applicable formatting patterns for numbers and dates in Webdesk EWP. The patterns described here are standardized throughout the system and can be used anywhere in Webdesk where a formatting pattern can be specified to display data in a customized way.

The formatting patterns used in Webdesk follow the formatting patterns standardized for Java. It is always based on the international comma setting ("dot" as comma and "comma" as optional thousands separator).

Formatting Patterns for numbers (numerical values)

Um eine Zahl zu formatieren, muss zunächst eine Struktur festgelegt werden. In dieser Struktur kann eine Zahl entweder durch '#' oder durch '0' ersetzt werden, je nachdem, ob bei nicht vorhandenen Werten trotzdem 0 angezeigt oder die Stelle frei bleiben soll. So ergeben sich zum Beispiel die folgenden Möglichkeiten.

To format a number, you must first define a structure. In this structure, a number can be replaced either by '#' or by '0', depending on whether 0 is to be displayed for non-existent values or whether the position is to be left blank. For example, you have the following options:

Number

Formatting Pattern

Output Format

1234.20

####.##

1234.2

1234.20

####,00

1234,20

You can also add any special characters or words when entering the formatting pattern, such as the usual thousands separators. Examples of this can be:

Number

Formatting Pattern

Output Format

12345678.90

###,###.##" hours"

12,345,678.9 hours

12345678.90

"€ " ###,###.00

€ 12,345,678.90

For more detailed information on the Java formatting patterns for numbers, click here .

Formatting Patterns for dates

The following abbreviations are used for the date formatting patterns in Webdesk:

y --> for year
M --> for month
d --> for day

These letters serve as "building blocks" for the date information and can be freely combined in different sequences with various special characters. In the following table, only a few examples are shown:

Date

Formatting Pattern

Output Format

24.02.1990

MM-dd-yyyy

02-24-1990

24.02.1990

dd.MMM.yyyy

24.Jan.1990

24.02.1990

MMM." "dd"th, "yyyy

Jan. 24th, 1990

For more detailed information on the Java formatting patterns for dates, click here.

Kommentare (0)