Skip to main content
DataType Functions

ToNumber Function

Use ToNumber to convert values from a different data type to a number.
ToNumber supports the following data types:
  • text
  • time
  • decimal number
Description 1 of 4 (convert a text value):
Convert a text value to a number value.
note
This function is non-evaluable if the text value does not correspond to a number.
Returns:
Number
Parameter:
Parameter
Data Type
Description
1
Text
The text to be converted.
Example:
When using functions inside a field, remember the field brackets:
{ToNumber(VariableName)}
Expression
Result
ToNumber( "-001.002000" )
-1.002
Description 2 of 4 (convert a time value):
Convert a time value to a number value.
The number returned, which is in the range 0 (inclusive) to 1 (exclusive), represents the fraction of a 24-hour day.
Returns:
Number
Parameter:
Parameter
Data Type
Description
1
Time
The time to be converted.
Examples:
When using functions inside a field, remember the field brackets:
{ToNumber(VariableName)}
Expression
Result
ToNumber( Time(0,0,0) )
0
ToNumber( Time(12,0,0) )
0.5
ToNumber( Time(23,59,59) )
0.999988425925926
Description 3 of 4 (convert a list of text values):
Convert a list of text values to a list of number values.
note
This function is non-evaluable if any of the text values do not correspond to a number.
Returns:
Number*
Parameter:
Parameter
Data Type
Description
1
Text*
The list of text values to be converted.
Example:
When using functions inside a field, remember the field brackets:
{ToNumber(VariableName)}
Expression
Result
ToNumber( "-001.002000", "2.34500", "4.0198", "3" )
List(-1.002, 2.345, 4.0198, 3)
Description 4 of 4 (convert a list of time values):
Convert a list of time values to a list of number values.
The number returned, which is in the range 0 (inclusive) to 1 (exclusive), represents the fraction of a 24-hour day.
Returns:
Number*
Parameter:
Parameter
Data Type
Description
1
Time*
The list of time values to be converted.
Examples:
When using functions inside a field, remember the field brackets:
{ToNumber(VariableName)}
Expression
Result
ToNumber( Time(0,0,0), Time(12,0,0), Time(23, 59, 59) )
List(0, 0.5, 0.999988425925926)

This article applies to:

  • Product: Contract Express

Related Content