Common Date Formula- FineBI Document

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
Yesterday	DATEDELTA("field name",-1)
First day of the year	DATE(YEAR(NOW()),01,01)
Data with time, minutes and seconds at the same time yesterday	NOW()-1
The display date is the week ordinal of the year	WEEK("field name")
Take the last day of the month corresponding to the "date" field	DATE(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 date	DAYSOFMONTH("Date")
Take the Monday corresponding to the week in the date field	DATEDELTA("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 located	DATEDELTA(date(year(MONTHDELTA("Date",1)),month(MONTHDELTA("Date",1)),1),-1)
Find the number of weeks in which the "date" is located	int((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".

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

Common Date Formula

1. Overview

2. Common date

3. Time field conversion

附件列表