Search…
Resources
Related 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 date.

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) and 02/06/2021 09:00 - 03/07/2021 18:00 (UK))
​
quarter(endof('Appointment test'))
Result: 3 (with “Appointment” = 06/02/2021 09:00 - 07/03/2021 18:00 (US) and 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

See also

​day, which converts to or returns a date value.
​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.
Export as PDF
Copy link