SOQTR

The SOQTR function returns the start date of the quarter for a given date. References and measures are also accepted as arguments. This function is commonly used to group data by quarter and calculate quarterly reporting periods.

Syntax

SOQTR(date)

Arguments

• date: The input date.

Return value

Returns the start date of the quarter.

Example

SOQTR("05/29/2026")

Returns 4/1/2026, which is the start date of the quarter containing 05/29/2026.