Quarter
The Quarter function returns an integer representing the quarter in which a specified date and time occurs.
For more information (including use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.
Syntax
Quarter(date)
Function arguments:
- date (required) - the date or column containing date values from which the quarter is determined
Sigma evaluates quarters based on the calendar year. The first quarter begins January 1, the second quarter begins April 1, the third quarter begins July 1, and the fourth quarter begins October 1.
Example
Quarter([DATE])
Evaluates the month and day of each value in the Date column and returns an integer representing the quarter in which each date occurs.
Quarter(Date("2007-08-14 07:11:05"))
Evaluates the month and day of the specified date (August 14, 2007) and returns 3 to represent the third quarter of the calendar year.