The formatting functions determine the display format of fields or expressions.
With these functions it is possible to set decimal separator, thousands
separator, and so on. The functions can be used both in data load scripts and chart expressions.
Information noteFor reasons of clarity, all number representations are given with
decimal point as decimal separator.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
The date function formats the
expression as a date according
to the given format-code string.
This script function formats
the expression as a time interval
according to the string given as a format-code.
If the format code is omitted, the time format set in the operating system
is used.
The money function formats the
expression numerically according
to the string given as format-code.
Decimal separator and thousands separator can be set as third and fourth
parameters. If the parameters 2-4 are omitted, the number format that
is set in the operating system will be used.
This script function formats the
expression numerically according
to the string given as format-code.
Decimal separator and thousands separator can be set as third and fourth
parameters. If the parameters 2-4 are omitted, the number format set in
the operating system is used.
The time function formats the expression as time according to the string
given as format-code. If the format code is omitted, the time format set
in the operating system is used.
This function formats
the expression as a date and
time according to the string given as format-code.
If the format code is omitted, the date and time formats set in the operating
system are used.
