WebMuseo Help - Formats
Number format
The pattern must contain at least one digit symbol [#], [,] must be used as the grouping separator and [.] must be used as the decimal separator. The positive pattern is given first, followed by a separator symbol [;], the an optional negative pattern. If the negative pattern is not given, [-] will be used as a prefix for negative numbers. All characters are translated literally, except for the following symbols:
Any character which is not a symbol can be defined as the "Number grouping separator" or "Number decimal separator".
Time format
The time format pattern must contain symbols for the "hour in month" and "minute in hour". The relevant symbols are:
Short date format
The short date format pattern must contain symbols for the "day in month", month and year. This pattern is used for data input and as well as for displaying the date. If it does not have numeric forms of the "day in month", month and year, as well as uniform grouping separators, the system will attempt to use a data input format according to the languages and countries defined in your profile.
The symbols that can be used (for both the long and short date formats) are:
Long date format
The long date format pattern must contain the following symbols: [Y] and ([M] or [w] or [W]) and ([D] or [d] or [F] or [E]).
The pattern must contain at least one digit symbol [#], [,] must be used as the grouping separator and [.] must be used as the decimal separator. The positive pattern is given first, followed by a separator symbol [;], the an optional negative pattern. If the negative pattern is not given, [-] will be used as a prefix for negative numbers. All characters are translated literally, except for the following symbols:
Symbol | Meaning |
0 | Digit |
# | Digit, zero shows as absent |
. | Decimal separator or monetary decimal separator |
- | Minus sign |
, | Grouping separator |
; | Separates positive and negative subpatterns |
' | Used to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock". |
Any character which is not a symbol can be defined as the "Number grouping separator" or "Number decimal separator".
Time format
The time format pattern must contain symbols for the "hour in month" and "minute in hour". The relevant symbols are:
Symbol | Meaning | Examples |
H | Hour in day (0-23) | 0 |
k | Hour in day (1-24) | 24 |
K | Hour in am/pm (0-11) | 0 |
h | Hour in am/pm (1-12) | 12 |
m | Minute in hour | 30 |
a | Am/pm marker | PM |
Short date format
The short date format pattern must contain symbols for the "day in month", month and year. This pattern is used for data input and as well as for displaying the date. If it does not have numeric forms of the "day in month", month and year, as well as uniform grouping separators, the system will attempt to use a data input format according to the languages and countries defined in your profile.
The symbols that can be used (for both the long and short date formats) are:
Symbol | Meaning | Examples |
G | Era designator | AD |
y | Year | 1996; 96 |
M | Month in year | July; Jul; 07 |
w | Week in year | 27 |
W | Week in month | 2 |
D | Day in year | 189 |
d | Day in month | 10 |
F | Day of week in month | 2 |
E | Day in week | Tuesday; Tue |
Long date format
The long date format pattern must contain the following symbols: [Y] and ([M] or [w] or [W]) and ([D] or [d] or [F] or [E]).
|