YEARDELTA - The Delta Years After the Specified Date- FineBI Help Document

Last update：December 15, 2024

Overview

Syntax

YEARDELTA(Date,Delta)

Returns the date several years (specified by delta) after the specified date.

Parameter

Date

Represents the date entered.

Besides the text and date types, the Date parameter can also be of the serial number type of the 1900 date system for extracted data. For example, the serial number 35796 represents 1998-01-01.
The Data parameter can only be of the date or text type for real-time data.

The function supports two parameters, with the first being a date or text parameter, and the second being a numeric parameter.

Formula	Result	Note
YEARDELTA("2008-10-10",10)	2018-10-10
DATEDELTA(35796,10)	2008-01-01	The format is not supported for real-time data.

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

English