YEAR

Returns the year portion of the specified date value.

Syntax

YEAR(dateval)

Example

If mydatefield has value '2024-10-30 09:55:00', then:

YEAR({{mydatefield}})

returns: 2024

Related

MONTH
DAY
HOUR
MINUTE
SECOND