反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

DATETONUMBER

  • Recent Updates: April 04, 2022

    • 1. Extracted data

    1）Overview

    SyntaxDATETONUMBER(date)Returns the number of milliseconds passed since 00:00:00GMT on January 1, 1970.
    Parameterdate

    date can be a text, a date, or a number. It is processed logically in the year 1900. For example, 35796 is 1998-01-01.  

    2）Precaution

    • Supports a date or text type parameter, if more than one parameter, that is invalid.

    3）Example

    FormulaResultRemark
    DATETONUMBER("2008-08-08")1,218,124,800,000
    DATETONUMBER(35796)883,612,800,000

    2. Real-time data

    1）Overview

    SyntaxDATETONUMBER(date)Returns the number of milliseconds passed since 00:00:00GMT on January 1, 1970.
    Parameterdate

    data supports only text and data types.

    2）Precaution

    • Supports a date or text type parameter, if more than one parameter, that is invalid.

    3）Example

    FormulaResultRemark
    DATETONUMBER("2008-08-08")1,218,124,800,000


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭