反馈已提交

网络繁忙

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

DATESUBDATE

  • Recent Updates: April 04, 2022

    • 1. Overview

    SyntaxDATESUBDATE(date1,date2,op)Returns the time difference between two dates.
    Parameter1date1

    date1,date2 indicates the two dates to be entered. If date1 is earlier than date2, the value is negative. date1 is later than date2 and is a positive value. If date1 or date2 is a value, the sequence number in 1900 is processed logically. For example, 35796 is 1998-01-01.

    Note: Only text and date types are supported for real-time data.

    Parameter2date2
    Parameter3opRepresents the unit of time returned: "s/S", in seconds. "m/M", in minutes." h/H", in hours."d /D", in days." w/W", in weeks.

    2. Precautions

    • Extracted data supports three parameters, the previous two date or text type parameters, the third requires text; The third parameter supports S, M, H, D, and W and is case insensitive.

    • In real-time data, the first and second date or text type parameters, and the third is a text type parameter.

    3. Example

    FormulaResultRemark
    DATESUBDATE("2008-08-08","2008-06-06","h")1512
    DATESUBDATE("2008-06-06","2008-08-08","H")-1512


    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后关闭