QUARTER

Description

The QUARTER function finds the quarter of a given date.

Usage

QUARTER(date)
Argument Type Required Description
date date yes The date for which to find the quarter

Remarks

The result will always be in the range 1 and 4.

Example

If you have a quarterly reporting frequency, you may only collect some indicators in the first and third quarters. You can use the following formula as a relevance rule:

QUARTER(REPORTING_DATE) == 1 || QUARTER(REPORTING_DATE) == 3
Next item
REGEXEXTRACT