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.

Options

Column Selection

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

DateTime Selection

Start
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. The selected date has the format yyyy-MM-dd, the selected time can either have the format HH:mm:ss or HH:mm:ss.SSS (where SSS stands for milliseconds).
Now
Inserts the current time formatted according to the format and locale.
Inclusive
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.
End
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. The selected date has the format yyyy-MM-dd, the selected time can either have the format HH:mm:ss or HH:mm:ss.SSS (where SSS stands for milliseconds).
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
or
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

Icon
Input table.

Output Ports

Icon
Filtered output table.

Views

This node has no views

Workflows

Links

Developers

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.