ToNumber

The ToNumber() converts a value to a number.

Syntax

ToNumber(text)
ToNumber(date, unit)

Returns

The number converted from text or a unit from date. If text is not a number then this function returns "unknown".

Parameters

• text – a text containing a number.
• date – a date.
• unit – the unit that is retreived from date.

Note: this function uses the language setting of a portal when converting text.

Examples

ToNumber("1.34")      /* 1.34 */
ToNumber("1,340")     /* 1340 */
ToNumber("2000")      /* 2000 */
ToNumber("")          /* unknown */

DatePart('2014-08-21T12:00:30', Year)          /* 2014 */
DatePart('2014-08-21T12:00:30', Month)         /* 8 */
DatePart('2014-08-21T12:00:30', Hour)          /* 12 */
DatePart('2014-08-21T12:00:30', Minute)        /* 0 */

DatePart(UnknownDateTime, Year)                /* unknown */