Date&Time-based Row Filter

Extracts all rows where the time value of the selected column lies within a given time window from the input. The time window is specified by a start and either an end date (and time), a duration or a numerical value combined with a granularity.


Column Selection

Date&Time Column
It will be filtered by the date/time of the selected column.

DateTime Selection

The start date (and time) determines the lower bound of the filter. It is only optional, i.e. if no start is defined, there is no lower bound.
Inserts the current time formatted according to the format and locale.
If checked, rows with a value equal to the start (or end) date will be kept in the output. If not checked, only rows with a value strictly later than start (or earlier than end) are kept.
Use Execution Time
If checked, the execution time will be used as filter value, i.e. every execution the current time will be inserted.
Optionally an end point or range can be chosen. If unchecked, there is no upper bound.
End: Date&Time
Select to insert an end date (and time) which determines the upper bound of the filter.
End: Duration
Select to insert a format string to use as filter range. All rows which are included in this range, will be in the output. A negative duration defines a range reaching back to the past. The inserted string can be either in
1. the ISO-8601 representation (see date-based duration format or time-based duration format for details), examples below,
2. the short letter representation (e.g. '2y 3M 1d')
Date-based duration: y: years, M: months, d: days
Time-based duration: H: hours, m: minutes, s: seconds
3. the long word representation (e.g. '2 years 3 months 1 day').

Examples for ISO-8601 (date-based duration):
  • "P2Y" parses as "+2 years"
  • "P-2Y" parses as "-2 years"
  • "P1Y2M3W4D" parses as "1 year, 2 months, 3 weeks and 4 days"
Examples for ISO-8601 (time-based duration)::
  • "PT15M" parses as "+15 minutes"
  • "-PT15M" parses as "-15 minutes"
  • "PT2H15M3.5S" parses as "2 hours, 15 minutes and 3.5 seconds"
End: Numerical
Select to insert an integer and a granularity to define a filter range. A negative value defines a range reaching back to the past. The granularity can be chosen in years, months, weeks, days, hours, minutes, seconds, milliseconds, nanoseconds.

Input Ports

Input table.

Output Ports

Filtered output table.


This node has no views


Further Links


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.