ToNumber
The ToNumber()
converts a value to a number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Note: this function uses the language setting of a portal when converting text.
Returns the number converted from text
or a unit from date
.
Returns Invalid expression
when text
is not a number, or when reference
is not a valid RowId, or when date
is not a valid date value or unit
is not a valid date unit.
Syntax
Parameters
Name | Type | Required | Description |
---|---|---|---|
| text | ☑️ | a text containing a number. |
| reference | ☑️ | reference field, holding a rowid of a list. |
| date | ☑️ | a date. |
| text | ☑️ | the unit that is retrieved from |
Last updated