Returns the month of the year for a given date.

Sample usage

MONTH(Hit time)


MONTH(X [,Input Format])


  • X - text, number or date field and expressions.
  • Input Format - format for X. Optional if X is correctly configured as a semantic date field.

Input format

MONTH 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

MONTH 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
MONTH(Hit time) Jan 1, 2019 January
MONTH(Hit time, 'BASIC') 2019/01/01-09:40:45 January
MONTH(Hit time, 'SECONDS') 1561784874 June
MONTH(Hit time, 'MILLIS') 1562004058620 July

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue