Filter rows/cells on date¶
Filter rows from the dataset using a date filter defined by a fixed date range, a relative date range, or a matching date part. Alternatively, clear content from matching cells rather than filter the rows.
Options¶
Action
Select the action to perform on matching (in range) rows or cells:
Keep matching rows only
Remove matching rows
Clear content of matching cells
Clear content of non-matching cells
Date column
Column containing data in ISO-8601 format. Use a Prepare step to parse the data into this format if it isn’t already. If the column doesn’t not contain a valid date for a row, this row is considered out of range.
Filter on
Choose how to define the date filter:
Date range: Use a fixed date range. The lower/upper boundaries are inclusive. If the lower bound is empty, all dates before the upper bound will match, and vice versa.
Relative range: Use a relative date range and time window (last N, next N, to date). The range is calculated relative to the current date and chosen date part. It will update itself over time.
Date part: Filter on date part falling within values in a list.