QUARTER_OF

Description

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

Quarter	Months
1	January to March
2	April to June
3	July to September
4	October to 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.