The ADDQTRS function adds or subtracts a specified number of quarters from a date. It is commonly used to calculate future or past quarter-based reporting periods.
Syntax
ADDQTRS(date,value)
Arguments
date: The input date. This can be a date value, measure, or reference.
value: The number of quarters to add or subtract. Use a negative value to subtract quarters.
Return value
Returns the calculated date.
Examples
ADDQTRS("05/29/2024",-1)
Returns 02/29/2024 by subtracting 1 quarter (3 months) from the input date.
Returns 11/29/2026 by adding 2 quarters (6 months) to the input date.
