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

Function	Description
DAYOF	Returns the day of the month as a number.
MONTHOF	Returns the month of the year as a number.
WEEKDAYOF	Returns the day of the week as a number.