YEAROF
Syntax
YEAROF(date_string [, input_format])
Parameters
date_string
A text representing a valid date.
input_format
One of the keywords in the table below, specifying the date format of date_string.
Description
YEAROF returns the year as a number for the date specified by the date_string. If input_format is not provided, the default keyword DELIM_M_D_Y will be used.
Examples
YEAROF("31082000", DDMMYYYY) returns the number 2000.
For additional information on valid date formats, see DATE.
Related Functions