DAY- FineBI Document

Last update： 2022-04-04

1. Overview

Syntax	DAY(serial_number,format)	Returns the day of the date. DAY is a number between 1 and 31.
Parameter	serial_number	The date containing the year requested. It can also be a series number, such as in a 1900 date system, where January 1, 1998 is stored as a series number of 35796. Note: The real-time data serial_number supports only text and date types. The DAY() parameter in DAY(serial_number, format) is allowed to be empty. If the parameter is empty, the DAY in the date corresponding to the server time of the current system is used.

Syntax

DAY(serial_number,format)

Returns the day of the date. DAY is a number between 1 and 31.

Parameter

serial_number

The date containing the year requested. It can also be a series number, such as in a 1900 date system, where January 1, 1998 is stored as a series number of 35796.

Note: The real-time data serial_number supports only text and date types.

The DAY() parameter in DAY(serial_number, format) is allowed to be empty. If the parameter is empty, the DAY in the date corresponding to the server time of the current system is used.

2. Precautions

Extracted data allows parameters to be null, supporting two parameters, the first parameter default date or text type, the second default parameter text.
Real-time data can use either a default date or a text-type parameter.
The second parameter supports the format yyyy-MM-dd.

3. Example

Formula	Result	Remark
DAY()	23	The corresponding system server time is 2020-10-23 15:36:25.
DAY("2000/1/1")	1	The real-time data does not support 2000/1/1 and must be written as DAY("2000-01-01").
DAY(35796)	1	Real-time data is not supported.
DAY("1997-04-20","yyyy-MM-dd")	20

Previous：TODATE

Next：MINUTE

Helpful
Not helpful
Only read

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

English

DAY

1. Overview

2. Precautions

3. Example

附件列表