QUARTER

The QUARTER function in Infoveave is used to extract the quarter from a given date.

Applicable to

Calculated Columns

Return Value

The QUARTER function returns the quarter value as an integer for a given date.

Remark

• The function is useful for extracting the quarter from dates for analysis, such as grouping data by quarter, performing year-over-year comparisons, and filtering data by quarter.
• The QUARTER function returns “Invalid Date” on null or blank values.

Syntax

QUARTER(<expression>)

Tip

You can call in the system defined date function start date and end date as @StartDate and @StartDate respectively.

QUARTER in Calculated Columns

Steps to Use

1. Write the QUARTER function. For instance QUARTER(<expression>)
2. Replace <expression> with the start period. You can also call in @StartDate and @EndDate function.
3. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Suppose you want to create a column that returns the quarter value based on the column SALES DATE, you can use the QUARTER function as follows

QUARTER (DATEVALUE(VALUE([Sales Date])))

Tip

When using the DATE function within WEEKDAY, you do not need to include the function DATEVALUE in your formula.

For example

QUARTER ((DATE(2024, 05, 01)))

will return 2.