The Compare to Relative Date Range criterion is available only when creating a criterion based on a date or date/time attribute.
It allows you to create a criterion that specifies that matching attribute values are between a defined Start and End relative to the point of the rule’s being run. The Relative Date Range Criterion Builder contains the following:
•Start section: containing the following
o [Dropdown]: this dropdown field exposes the following values:
§ Is now
§ Is before now (the default)
§ Is after now
§ Has no limit
o Duration: this integer property is only shown when [Dropdown] one of Is Before Now or Is After Now. It defaults to the value 1, and accepts a minimum value of 1, and a maximum value of 999,999.
o [Units]: this dropdown field exposes the following values:
§ seconds
§ minutes
§ hours
§ days
§ months
§ years
•End section: containing the same properties as Start.
‘No limit’ values at Start and End are not supported concurrently. Any values configured at the criterion must make sense from a temporal perspective.
When a compare to relative date range criterion is shown at a standard selection rule, if reflects its configuration as defined in the Criterion Builder.
Note that this feature is not supported at the Apache SparkSQL, Google Big Table, Hive, Netezza, SAP HANA and SalesforceDB databases.
Note also that the Compare to Relative Date Range criterion is not supported at Google BigQuery when a date field's Mode property is set to 'Repeated'.