YEAROF macro

The YEAROF macro is available only in Unica Campaign.

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.