MONTH

MONTH takes a date object or a function such as NOW and returns an integer representing the day of the month on which it falls. Use the coerce-to-string function to convert the result to a string. The structure of the date response returned follows the ISO 8601 standard.

+ / - operations can be used with the MONTH function, such as MONTH() - 3 or MONTH() + 1.

Function category: Date

Syntax

MONTH(arg1)

Arguments

Descriptions

arg1

Date object or a function that resolves to a time object.

Example 1

Enter the following into the Formula editor to return the date using the NOW function. This returns the current month.

# Find the current day
MONTH(NOW())
# This function returns
8
# if the current month is August.

Example 2

Enter the following into the Formula editor to return the current month as a string using the MONTH function wrapped in the coerce-to-string function and having the NOW function as the argument.

# Find the current month and return a string
coerce.to-string(MONTH(NOW()))
# This function returns the string
"8"
# if the current month is August