PERIOD_RANGE

The PERIOD_RANGE function returns an array of dates between two specified dates. This function is commonly used with functions such as FILTER to evaluate and analyze data within a specific date range.

Syntax

PERIOD_RANGE(fromDate, toDate)

Arguments

• fromDate: The start date of the range.

• toDate: The end date of the range.

Return value

Returns an array of dates within the specified range.

Example

PERIOD_RANGE(DATE(2023, 1, 1), DATE(2023, 12, 31))

Creates a date range for all dates in the year 2023.

Usage with forecasts

The PERIOD_RANGE function can be used with forecast data to analyze values within open forecast periods. In this scenario:

• PERIOD_RANGE selects the open forecast periods.

• FILTER returns forecast values greater than 1000 within those periods.

• An aggregate function such as SUM calculates the total of the filtered forecast values.