反馈已提交

网络繁忙

Common Date Formula

  • Last update:  2022-04-26
  • 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".

    附件列表


    主题: Advanced Data Analysis
    • Helpful
    • Not helpful
    • Only read

    feedback

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

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

    不再提示

    10s后关闭