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