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​
MONTH(arg1)
Arguments | Descriptions |
| Date object or a function that resolves to a time object. |
Enter the following into the Formula editor to return the date using the NOW function. This returns the current month.
# Find the current dayMONTH(NOW())​# This function returns8# if the current month is August.
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 stringcoerce.to-string(MONTH(NOW()))​# This function returns the string"8"# if the current month is August