You can customize number and date formats to reflect local requirements. This can be to specify the default decimal separator in number formats such as prices or percentages or date formats based and region. For example, while many European countries commonly use day-month-year (d/m/y) with time based on the 24-hour clock (11:52), the common standard in North America is month-day-year (m/d/y) with time based on the 12-hour notation (11:52 am).
This article details the different formats available based on the property type selected for:
The tables detailing the different formatting options are provided below in individual sections.
Applying formats for numbers
When you create new property, you are requested to specify the property Type (A). The default format (B) applied can be adjusted. In the example below, the property is given the name Month (C) and the format mmmm (D) is applied. Press Save (E) to save the details provided. |
 |
Formatting available for dates
You can apply the formats as detailed in the following table for the property Types,
Date,
Date-Time
Time
The property is displayed as detailed below in the user interface for your application.
Format: | Displayed as: | Description: |
YY YYYY | 21 2021 | Two-digit year Four-digit year |
M MM MMM MMMM | 1-12 01-12 Jan-Dec January - December | Month, beginning at 1 Month, 2-digits Abbreviated month name Full month name |
D Dd | 1-31 01-31 | Day of the month Day of the month, 2-digits |
d dd ddd dddd | 0-6 Sun-Sa Sun-Sat Sunday-Saturday | Day of week, Sunday - 0 Min. name day of week Short name day of week Name day of week |
H HH | 0-23 00-23 | Hour Hour, 2-digits |
h hh | 1-12 01-12 | 12-hour clock 12-hour clock, 2-digits |
m mm | 0-59 00-59 | Minute Minute, 2 digits |
s ss | 0-59 00-59 | Second Second, 2 digits |
SSS | 000-999 | Millisecond, 3 digits |
Z ZZ | +5:00 +500 | Offset UTC, ±HH:mm Offset UTC, ±HHmm |
A a | AM am | AM/PM in capitals am/pm in lowercase |
Formatting available for Numbers
You can apply the formats as detailed in the following table for the property Types,
Number
Number with decimal
Price
Specific formats can also be set for presenting distance and percentages or percentiles. The tables below show the number format required based on how you want information displayed on your user interface.
Input number specified: | Required to display as (see Note 1 below for postfix details): | Specify Format as: (see Note 1 below for postfix details): |
1230974 | 1.2m |
|
1460 | 1 k |
|
-104000 | -104k |
|
Note 1:
|
Input number specified: | Required to display as (see Note 2 below for details of postfixes): | Specify Format as: (see Note 2 below for details of postfixes): |
1 | 1st |
|
100 | 100th |
|
Note 2: When the format involves using
|
Number formats
Input number specified: | Required to display as: | Specify format as: |
10000 | 10.000,00 |
|
10000 | 10,000,00 |
|
10000 | 10000,00 |
|
10000 | 10.000 |
|
10000 | 10,000 |
|
10000 | 10000 |
|
Input number specified: | Required to display as: | Specify format as: |
10 | 010.00 |
|
0.23 | 0.23000 |
|
10000 | 10.000,00 |
|
-10000 | -10,000.0 |
|
10000,23 | 10,000,2 |
|
10000,23 | +10,000,2 |
|
100,1234 | 00100 |
|
1000,1234 | 001,000 |
|
10000,1234 | 10000.123 |
|
10000,1234 | 10000.12340 |
|
Format Price property
You can apply specific price formatting options when you select the Price as the Type when creating a new property.
You can scroll through the Type menu and select Price. The default format is applied (
For example, if the number 10000 is entered in a field based on this property type, it is presented in the interface as €10,000.00.
Note: Any text that is placed between quotation marks ( |  |
Input number specified: | Required to display as: | Specify format as: |
1000.234 | €1,000.23 |
|
1000,2 | 1.000,2 € |
|
1001 | € 1.001,0 |
|
-1000,234 | €1000,0 |
|
-1000,234 | € -1000.23 |
|
1230974 | € 1.23 m |
|
123,23 | MyCurrency 123.23 |
|