Month

The Month function returns an integer representing the month component of a specified date and time.

Syntax

Month(date, [timezone])

The Month function has the following arguments:

date

(Required) The date or the column that contains date values where Analytics Pro extracts the month component.

timezone

(Optional) The IANA time zone; for example, (e.g., “America/Los_Angeles”, used to convert the date value before extracting the month component. When omitted, timezone Analytics Pro evaluates the date in UTC time.

Required

Examples

Month(Date("2007-08-14"))

Extracts the month component from the specified date (August 14, 2007) and returns 8 to represent the eighth month of the year.

Month([Date])

The Month function returns the following values for the Date column:

Last updated

Was this helpful?