反馈已提交

网络繁忙

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

DAY

  • Recent Updates: April 04, 2022

    • 1. Overview

    SyntaxDAY(serial_number,format)Returns the day of the date. DAY is a number between 1 and 31.
    Parameterserial_number

    The date containing the year requested. It can also be a series number, such as in a 1900 date system, where January 1, 1998 is stored as a series number of 35796.

    Note: The real-time data serial_number supports only text and date types.

    The DAY() parameter in DAY(serial_number, format) is allowed to be empty. If the parameter is empty, the DAY in the date corresponding to the server time of the current system is used.

    2. Precautions

    • Extracted data allows parameters to be null, supporting two parameters, the first parameter default date or text type, the second default parameter text.

    • Real-time data can use either a default date or a text-type parameter.

    • The second parameter supports the format yyyy-MM-dd.

    3. Example

    FormulaResultRemark
    DAY()23The corresponding system server time is 2020-10-23 15:36:25.
    DAY("2000/1/1")1The real-time data does not support 2000/1/1 and must be written as DAY("2000-01-01").
    DAY(35796)1Real-time data is not supported.
    DAY("1997-04-20","yyyy-MM-dd")20


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