BUILTIN.PERIOD

This function returns the contents of the IN predicate for a relative date range as a sub-selection.

Parameters

Parameter	Required / Optional	Description	Accepted Parameter Values
Range ID	Required	The supported date ranges in relative dates.	See RelativeDate.dateId Property values in the table on query.RelativeDateRange for list of supported values. For example, use `'LFY'` to represent Last Fiscal Year in your queries.
Range type	Required	Represents supported period range filters.	`'START'` `'END'`
Adjustment	Required	Represents supported adjustment period filters. For more information, see Adjustment Periods.	`'NOT_LAST'` `'ALL'`
Operator	Required	The supported operators for filters.	`'BETWEEN'` `'NOT BETWEEN'` `'<'` `'<='` `'>'` `'>='`

Parameter

Required / Optional

Description

Accepted Parameter Values

Range ID

Required

The supported date ranges in relative dates.

See RelativeDate.dateId Property values in the table on query.RelativeDateRange for list of supported values.

For example, use 'LFY' to represent Last Fiscal Year in your queries.

Range type

Required

Represents supported period range filters.

Adjustment

Required

Represents supported adjustment period filters.

For more information, see Adjustment Periods.

Operator

Required

The supported operators for filters.

            BUILTIN.PERIOD('LFY', 'END', 'NOT_LAST', '>')

            BUILTIN.PERIOD('LFY', 'START', 'ALL', 'BETWEEN')