In a formula-type column, the QUARTER() function displays the quarter number of a date-type column.
-
Date function name:
QUARTER()
Syntax
QUARTER(date_column)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date-type column for which you want the quarter. |
Example
QUARTER($Date)
For a date in April, the column returns 2 (2nd quarter).
Return Type
The function returns a number (the quarter, from 1 to 4).
The output type format can be configured in the output field options of the formula editor. For more details, see Output Format Options in the Formula Column article.
Business Use Case
QUARTER() structures quarterly reporting: aggregate revenue by quarter, track goals from Q1 to Q4.
Best Practice
Combine QUARTER() with YEAR() (or use YEAR_QUARTER()) to distinguish the same quarter across different years.