QUARTER

Retrieves the quarter of the year from a given date or datetime

Updated over a week ago

Description

The QUARTER() function extracts and returns the quarter of the year (e.g., 1, 2, 3, 4) from a given date or datetime. This is useful for time-based analysis, organizing data by quarters, or generating quarterly reports.

Syntax

QUARTER(date)

Output

integer

Variables

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

Example

QUARTER(`Date`)

Statement

Date

QUARTER

Statement A

2023-03-15

1

Statement B

2023-07-30

3

Statement C

2023-11-05

4

Did this answer your question?