In a formula-type column, the YEAR_QUARTER() function displays the year and quarter of a date-type column. It serves as a quarterly reporting key across multiple fiscal years: comparing Q2 from one year to another.
Syntax
YEAR_QUARTER(date_column)
Parameters
The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Examples
Display the year and quarter
YEAR_QUARTER($Date)
The column returns the year and quarter corresponding to the date.
Placing the year before the quarter ensures correct chronological sorting when moving from one year to the next.
Go further
YEAR_WEEK
Combine the year with the week instead of the quarter.
Or continue with
Formula glossary
All available operators and functions, sorted by category.