SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / DATEVALUE
In This Topic
    DATEVALUE
    In This Topic

    This function returns a DateTime object of the specified date.

    Syntax

    DATEVALUE(date_string)

    Arguments

    The argument for this function is a date as a string.

    Remarks

    Use this function to convert a date represented by text to a DateTime object in standard format.

    Data Types

    Accepts string data. Returns a DateTime object.

    Examples

    DATEVALUE(B18)

    DATEVALUE(R18C2)

    DATEVALUE("2004/10/6") gives the result 10/6/2004 12:00:00 AM

    See Also