DAYVALUE- FineBI Help Document FineBI Document

Recent Updates: April 04, 2022

1. Overview

Syntax	DAYVALUE(date)	Returns the number of days from 1900 to date.
Parameter	date	In addition to supporting text and date types, date extracted data can also be series number. For example, in the date system of 1900, that January 1, 1998 is stored as series number 35796. Note: Only text and date types are supported for real-time data.

Syntax

DAYVALUE(date)

Returns the number of days from 1900 to date.

Parameter

date

In addition to supporting text and date types, date extracted data can also be series number. For example, in the date system of 1900, that January 1, 1998 is stored as series number 35796.

Note: Only text and date types are supported for real-time data.

2. Precaution

Supports a date or text type parameter, if more than one parameter, that is invalid.

3. Example

Formula	Result	Remark
DAYVALUE("2008/08/08")	39667	The real-time data format cannot be 2008/08/08. You need to write it in 2008-08-08 format.
DAYVALUE(35796)	35795

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

DAYVALUE

1. Overview

2. Precaution

3. Example

Attachment List