YEAR - Returning the Year- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	YEAR(text/date,format)	Returns the year of a date.
Parameter 1	text/date	The returned value is an integer ranging from 1900 to 9999.
Parameter 2	Format
Type of the Returned Value	Value

Notes

The function allows the parameters to be empty. That is, you can simply use YEAR(). If the parameters are empty, the function returns the year of the current system server time.

If any parameter is NULL, the result is NULL.

Example

Formula	Result
YEAR()	2020, corresponding to the system server time at 2020-10-23 15:36:25.
YEAR("2000/1/1")	2000
YEAR("1997-04-20","yyyy-MM-dd")	1997

Previous：Date Function Overview

Next：MONTH - Returning the Month of a Date

Helpful
Not helpful
Only read

中文（简体）

English

YEAR - Returning the Year

Overview

Notes

Example

附件列表