Search…
Resources
Related Links
format
To format a given value
With the function, you can format numbers, date, and time values as you need them, as use them in text or function fields.
Number formatting requires a period for the decimal separator and a comma for the thousands separator, e.g. "1.000,00".

Syntax

format(number, string)
format(date, string)
format(date, string, string)
format(appointment, string)
format(appointment, string, string)
format(timestamp, string)
format(timestamp, string, string)
format(time, string)

Return

string

Examples

Your result format may be different depending on your settings.
format(myNumber, formatExpression) To format a given number as a string.
format(12345678.9, "#,##0.00 €")
Result: 12,345,678.90 €
format(12345, "0000000000")
Result: 0000012345
format(myDate, formatExpression) To format a given date as a string.
format(Date, "ddd, Do MMMM YYYY")
Result: Mon, 31st May 2021 (with “Date” = 31/05/2021) (UK) and Mon, May 31, 2021 (with “Date” = 05/31/2021) ((US)
format(myDate, formatExpression, language) To format a given date as a string, where the result shows in a specific language supported by Ninox.
format(myDatetime, formatExpression) To format a given timestamp as a string.
format(now(),"X")
Result: 1622466387 (on May 31, 2021 15:06) "X" shows the result without Milliseconds! "x" shows the result with Milliseconds.
format(myAppointment, formatExpression) To format a given start of an appointment as a string.
format(myAppointment, formatExpression, language) To format a given start of an appointment as a string, where the result shows in a specific language supported by Ninox.
format(myTime, formatExpression) To format a given time as a string.
format(myDatetime, formatExpression, language) To format a given timestamp as a string, where the result shows in a specific language supported by Ninox.
See our table for more information about date and time format expression.
Last modified 2mo ago
Export as PDF
Copy link