Nevron Vision for SharePoint Documentation
Type Functions
Syntax Description Example
EMPTY() Returns the empty variant value.

EMPTY()
Returns: the empty variant

ISARRAY(var) Returns true if the variant is array. Otherwise returns false.

ISARRAY(ARRAY(10,20))
Returns: true

ISARRAY(10)
Returns: false

ISBOOL(var) Returns true if the variant is a boolean. Otherwise returns false.

ISBOOL(true)
Returns: true

ISBOOL(false)
Returns: true

ISBOOL("true")
Returns: false

ISDATETIME(var) Returns true if the variant is a date time. Otherwise returns false.

ISDATETIME(10)
Returns: false

ISDATETIME(DATETIME("2008-09-15T09:30:41.770"))
Returns: true

ISEMPTY(var) Returns true if the variant is empty. Otherwise returns false.

ISEMPTY(EMPTY())
Returns: true

ISEMPTY(true)
Returns: false

ISNUM(var) Returns true if the variant is a number. Otherwise returns false.

ISNUM(10)
Returns: true

ISNUM(true)
Returns: false

ISSTR(var) Returns true if the variant is a string. Otherwise returns false.

ISSTR(true)
Returns: false

ISSTR("hello world")
Returns: true

ISTIMESPAN(var) Returns true if the variant is a time span. Otherwise returns false.

ISTIMESPAN(true)
Returns: false

ISTIMESPAN(TIMESPAN("10.20:30:40.50"))
Returns: true

TOBOOL(var) Safely casts a variant to a boolean variant. Returns EMPTY, if the cast cannot be performed.

TOBOOL("false")
Returns: false

TOBOOL("true")
Returns: true

TOBOOL("hello")
Returns: the empty variant

TODATETIME(var) Safely casts a variant to a data time variant. Returns EMPTY, if the cast cannot be performed.

TODATETIME("2008-09-15 09:30:41.770")
Returns: the date and time

TODATETIME("hello")
Returns: the empty variant

TONUM(var) Safely casts a variant to a number variant. Returns EMPTY, if the cast cannot be performed.

TONUM(true)
Returns: 1

TONUM("10")
Returns: 10

TONUM("hello")
Returns: the empty variant

 

 


©2016. Nevron Software LLC.

Send Feedback