To convert a given value to a number

It returns the values of different data types as a number. You can imagine this is needed quite often.

The result depends on the data type. Some examples:

• A text consisting only of digits is converted to a number, for example,
• date and time are mapped in Unix time.
• In an appointment, Ninox refers by default to the start, if you don't explicitly refer to the end with endof().
• A time interval will be converted to milliseconds.
• Applied to a choice field, it returns the number of the selected option.

Syntax

number(any)

Return

number

Examples

number(today())

Result: 1638226800000 (for example on November 30, 2021 in Germany)

number("000075639")

Result: 75639 (the text is now a number and can be processed in further calculations)

See also

appointment which converts given time-related values to an appointment.

date converts to or returns a date value.

datetime converts to or returns a timestamp

text which converts a value to a string and possibly reflects the format options.

time which returns the current time.