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.