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.
4. To learn how to configure an Expression in Infoveave, visit Configure Expression.

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.