Date Range Generator (P&G)

A utility node that helps generate specific start and end dates. This can particularly be helpful when setting up loops for different queries. Date ranges can be created for either Month, Week, Daily or Adhoc periods. For instance you can specify that you would like to create monthly segments between 1/1/2014 and 12/31/2014 - resulting in 12 ranges (1/1/2014 - 01/31/2014, 2/1/2014 - 2/28/2014, etc.)

Output Columns:
From Date	Date-type representing start of range ("from")
From String	String-type representing start of range ("from")
To Date	Date-type representing end of range ("to")
To String	String-type representing end of range ("to")

Options

Start Date: The date to begin range creation
End Date: The date to end range creation
Date Range: Either "Month", "Week", "Day" or "None" based on how you want the date range to be created
String format: The format you would like date in (for String output)

Input Ports

This node has no input ports

Output Ports

: Data table containing the resulting date ranges.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

TestKNIME Forum

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.

Installation

To use this node in KNIME, install the extension General Use Utility Nodes for KNIME Workbench from the below update site following our NodePit Product and Node Installation Guide:

v4.5

A zipped version of the software site can be downloaded here.

Plugin provider: Procter & Gamble

Plugin version: 1.0.13.201908171104

On NodePit since: 2021-12-06

Last update: 2022-05-16

KNIME versions: Since v3.6

NodePit ExclusiveOnly available on NodePit