反馈已提交

网络繁忙

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

Common date formula

  • Recent Updates: April 26, 2022

    • 1. Overview

    This paper arranges some date formulas commonly used, so that users can quickly use these formulas in data processing and analysis, and improve the analysis efficiency.

    2. Common date

    Demand
    		Formula
    YesterdayDATEDELTA("field name",-1)
    First day of the yearDATE(YEAR(NOW()),01,01)
    Data with time, minutes and seconds at the same time yesterdayNOW()-1
    The display date is the week ordinal of the yearWEEK("field name")
    Take the last day of the month corresponding to the "date" fieldDATE(YEAR("Date"),MONTH("Date")+1,1-1)
    Take the last day of the month corresponding to "current time" (now)DATE(YEAR(TODAY()),MONTH(TODAY()),DAYSOFMONTH(TODAY()))
    Take the days of the month corresponding to the dateDAYSOFMONTH("Date")
    Take the Monday corresponding to the week in the date fieldDATEDELTA("Date",1-WEEKDAY("Date"))
    How many days have passed (left) since the "date"DATEDIF(date(year("Date"),month("Date"),1),today(),"D")
    Find the month end of the month when the "date" is locatedDATEDELTA(date(year(MONTHDELTA("Date",1)),month(MONTHDELTA("Date",1)),1),-1)
    Find the number of weeks in which the "date" is locatedint((day("Date")-(7-weekday(TODATE(YEAR("Date"),MONTH("Date"),1))))/7)+2

    Note: the date field needs to be selected from the field on the left of the function edit box and cannot be entered manually.

    3. Time field conversion

    For more details, see file: "date and string conversion".

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