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. |
