MONTH

Retrieves the month component from a given date

Description	The MONTH function extracts and returns the month component from a given date or datetime. This is useful for date-based analysis, organizing data by months, or generating monthly reports.
Syntax	MONTH(date)

1. date: The date or datetime from which you want to extract the month component.

Example

Table

Transaction	Sale Date
Transaction A	2023-09-10
Transaction B	2023-08-25
Transaction C	2023-09-01

Function

Month(`Sale Date`)

Results

Month(Sale Date)
9
8
9