Overview of date function- FineBI Help Document FineBI Document

Recent Updates: May 05, 2022

1. Overview

1.1 Version

FineBI	JAR	Function changes
5.1	-	-
5.1.7	2020-11-05	Optimize definition of functions Clarify the validity of function parameter
5.1.11	2021-04-02	Enhance real-time data function check
5.1.12	-	Enhance extracted data function check Add function QUARTER

1.2 Use location

	Use location
Self-service dataset	Add a column、Filter
Dashboard	Add caculation indicator

Note: If use a date as the parameter in a function, the format of the date must be yyyy/mm/dd or yyyy-MM-dd and it must be encloased by double quotes(" ").

1.3 Common date functions

The document provides some commonly used date functions to let users use them conviniently. For detailed description, please view: Common data functions.

2. Function list

Function	Description
MONTH	Return the month of the date. Month is a value between 1 and 12.
YEAR	Return the year of the date. Year is a value between 1900 and 9999.
DAY	Return the day of the date. Day is a value between 1 and 31.
DAYSOFYEAR	Return the number of days in a specified year.
MONTHDELTA	Return a date which is delta months after a date.
DATEDIF	Return the number of days, months or years between 2 specified dates.
DATEDELTA	Return a date which is delta days after a date.
WEEKDATE	Return the date of the specified year, month and week.
DAYS360	According to the rule that there are 360 days in a year (let there are 30 days in a month and 12 month in a year), return the number of days between 2 dates and this can be used in accounting. If the accounting system is based on 12 months a year and 30 days a month, this function can help to calculate the payment.
TODATE	Converts various date forms to date types.
LUNAR	Returns the lunar time corresponding to a date.
MINUTE	Return the minute of a specified time and the value is an integer between 0 and 59.
DAYSOFMONTH	Return the number of days between 1900.1 and a certain month in a certain year.
DATESUBDATE	Return the time difference between 2 dates.
DATETONUMBER	Return the number of milliseconds passed from 1970.1.1 00:00:00GMT.
DAYVALUE	Return the number of dates between 1900 and date.
DATE	Return a value that represents a specified date.
NOW	Return current time.
HOUR	Return the hour of a specified time. Hour is an integer between 0(0:00) and 23(23:00).
YEARDELTA	Return a date which is delta years after a date.
DAYSOFQUARTER	Return the number of days between 1900.1 and a certain quarter in a certain year.
WEEK	Return a number that represents the week of a year.
WEEKDAY	Get the date and return the day in a week. The returned value in an integer between 0 and 6, and 0-6 represent the day in a week respectively(from Sunday to Saturday).
TODAY	Return the date today.
TIME	Return a value that represents a specified time.
SECOND	Return the second of a specified time and the value is an integer between 0 and 59.
QUARTER	Return the quarter of the time. If the parameter is null, return the quarter of current server time.

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

Overview of date function

1. Overview

1.1 Version

1.2 Use location

1.3 Common date functions

2. Function list

Attachment List