QUARTER_OF

Description

QUARTER_OF returns the quarter of the year (1–4) for a given date.

Quarter	Months
1	January – March
2	April – June
3	July – September
4	October – December

Syntax

QUARTER_OF(date)

Returns: An integer from 1 to 4.

Example

p is Person
QUARTER_OF(p.contract_start_date)

If the contract start date is 2024-08-15, this returns 3.