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.

printTable

queryConnection

Last modified 7mo ago