Skip to main content
MONTH

Retrieves the month component from a given date

Updated over a year ago

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)

Output

integer

Variables

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

Example

MONTH(`Sale Date`)

Transaction

Sale Date

MONTH

Transaction A

2023-10-09

9

Transaction B

2023-25-08

8

Transaction C

2023-01-09

9

Did this answer your question?