Skip to main content
All CollectionsBuilding your applicationData modelReferences
Property format reference for numbers and dates
Property format reference for numbers and dates

Specify the number format you need for representing your data. Date and time formats can also be adjusted for local requirements.

Updated over a week ago

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:

  • Prices (based on number formats with specific formatting for pricing detailed)

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

Input component formatting

Input components, such as the Time component or the Date time component, can only use the lowercase 'a' format for am/pm notation and will show in capital.

The input functionality will ask for AM or PM, and according to your model notation be saved in your model in either capital or lowercase. It will also be displayed according to your model settings.

For more information on input component formatting, see this article (external link).


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

0.0a

1460

1 k

0 a

-104000

-104k

0a

Note 1:

a in the format is used to specify averages. Where the format involves an average, a is applied as follow:

  • Where a number is less than 1000, a postfix is not applied

  • if a number is between 1000 and 999999, the postfix k is applied

  • if a number is greater than 1000000, the postfix m is applied

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

0o

100

100th

0o

Note 2:

When the format involves using o (ordinal), the postfix:

  • st, nd and rd is applied for 1, 2, 3

  • th is applied for other numbers.

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

000.00

0.23

0.23000

0.00000

10000

10.000,00

0.0,00

-10000

-10,000.0

0,0.0

10000,23

10,000,2

0,0

10000,23

+10,000,2

+0,0

100,1234

00100

00000

1000,1234

001,000

000000,0

10000,1234

10000.123

0.000

10000,1234

10000.12340

0[.]00000


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 (€0,00).

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 (") is used as the currency symbol while any currency symbol supported by a keyboard glyph can be used without quotation marks.

Input number specified:

Required to display as:

Specify format as:

1000.234

€1,000.23

€0,0.00

1000,2

1.000,2 €

0,0[.]00 €

1001

€ 1.001,0

€ 0,0[.]00

-1000,234

€1000,0

€0,0

-1000,234

€ -1000.23

€ 0.00

1230974

€ 1.23 m

€ 0.00 a

123,23

MyCurrency 123.23

"MyCurrency" 0.00

Did this answer your question?