Returns the year of a given date.

Sample usage

YEAR(Hit time)


YEAR(X [,Input Format])


  • X - a field or expression that evaluates to text, number, or date.
  • Input Format - format for X. Optional if X is correctly configured as a semantic date field.

Input format

YEAR accepts the following input formats if X is a text field.

  • Any valid strptime format is accepted.
  • 'BASIC': %Y/%m/%d-%H:%M:%S
  • 'DEFAULT_DASH': %Y-%m-%d [%H:%M:%S]
  • 'DEFAULT_SLASH': %Y/%m/%d [%H:%M:%S]
  • 'DEFAULT_DECIMAL': %Y%m%d [%H:%M:%S
  • 'RFC_1123': for example, Sat, 24 May 2008 20:09:47 GMT
  • 'RFC_3339': for example, 2008-05-24T20:09:47Z

YEAR accepts the following input format if X is a numerical field.

  • 'SECONDS': seconds since Epoch
  • 'MILLIS': milliseconds since Epoch
  • 'MICROS': microseconds since Epoch
  • 'NANOS': nanoseconds since Epoch
  • 'JULIAN_DATE': days since Epoch


Formula Input Output
YEAR(Hit time) Jan 1, 2019 2019
YEAR(Hit time, 'BASIC') 2019/01/01-09:40:45 2019
YEAR(Hit time, 'SECONDS') 1561784874 2019
YEAR(Hit time, 'MILLIS') 1562004058620 2019

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue