quarter

To return the quarter of a given date as a number

This function will return the quarter of a given date as a number with the 1st quarter = 1, … 4th quarter = 4.

This can be helpful when filtering, sorting, and/or grouping records with a calendar reference.

If you use the function together with an appointment, make sure to specify if you need the start or the end.

Syntax

quarter(date)

Return

number

Examples

quarter(Date) 

Result: 2 (with Date = 06/02/2021 (US) and 02/06/2021(UK))

quarter(start(Appointment)) 

Result: 2 (with Appointment =

• 06/02/2021 09:00 - 07/03/2021 18:00 (US)

• 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

quarter(endof(Appointment)) 

Result: 3 (with Appointment =

• 06/02/2021 09:00 - 07/03/2021 18:00 (US)

• 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

See also

date, which converts to or returns a date value.

day, which returns the day of the month from a given date value as a number.

month, which returns the month from a date value as a number.

week, which returns the calendar week of a given date value.

year, which returns the year of a given date value.

yearquarter, which returns the quarter and the year of a given date value.