Nevron Vision for SharePoint Documentation
Pivot Engine / Functions / Type Functions
In This Topic
    Type Functions
    In This Topic
    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

    Send Feedback