0
number
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.
Reply
Related articles
Content aside
- 5 mths agoLast active
- 178Views
-
1
Following