Date - Relative First and Last

Returns relative start and end dates for this month, next month, previous month, or current quarter based on the selected Date columns



@takbb Brian Bates 23 Dec 2023
30 Dec 2023 - v2 replaces Java Snippet in column loop with a series of String Manipulation (Multi Column) nodes for improved performance on large datasets.

Options

Choose Date columns
Select the Date columns for which relative first/last dates are required
Date to return
Choose the dates to be returned based on the selected column value

Input Ports

Icon
Data table containing Local Date columns

Output Ports

Icon
Data table containing the additional columns based on the requested relative date calculations

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2023-12-23
Last update: 2026-01-13
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!