YEARDELTA- FineBI Help Document FineBI Document

Recent Updates: April 04, 2022

1. Overview

Syntax	YEARDELTA(date, delta)	Returns the date in the delta year after the specified date.
Parameter	date	Represents the date entered. In the extracted data, date supports not only text and date types, but also series number of 1900, for example, 35796 is 1998-01-01. Only text and date types are supported in real-time data.

Syntax

YEARDELTA(date, delta)

Returns the date in the delta year after the specified date.

Parameter

date

Represents the date entered.

In the extracted data, date supports not only text and date types, but also series number of 1900, for example, 35796 is 1998-01-01.
Only text and date types are supported in real-time data.

Supports two parameters, the first of date or text type and the second of numeric type.

Formula	Result	Remark
YEARDELTA("2008-10-10",10)	2018-10-10
YEARDELTA(35796,10)	2008-01-01	Real-time data does not support this notation.

Already the First

Already the Last

售前咨询电话

400-811-8890转1

在线技术支持

在线QQ：800049425

热线电话：400-811-8890转2

总裁办24H投诉

热线电话：173-1278-1526

文档反馈

鼠标选中内容，快速反馈问题

鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

不再提示

10s后关闭