Search…
⌃K
Links

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

1
quarter(Date)
Result: 2 (with Date = 06/02/2021 (US) and 02/06/2021(UK))
​
1
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))
​
1
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.