Icon

Start Workflow on Specific Day of Month

Start Workflow on Specific Date

Runs workflow on 2nd weekday of month. Fails on other dates.

The date manipulation portion of the workflow was created by BI-FI Blog. Check their blog for detailed guide.


Surrogate for Workflow. Remove Dates & RecreateOriginal Data Table. Input Start &End DatesCreates AllDates in Start/EndRange STEP 3Filters 2nd Dayin MonthCreates Factorto Move Weekends& MondaysCreates 2ndWeekday inMonthExtracts NewDateExtratcs New Dayof MonthExtracts CurrentSystem Date.Use in Production.Joins Datesin Table & Current Date.Fails if no Match.Test for Datein TableModel Data(Cannot HaveMissing Data)With Date Match AddsModel DataNode 50Node 51Enter Startand End Date Date RangeGeneration Adding Metadata Row Filter Rule Engine Date&Time Shift Extract Date&TimeFields Extract Date&TimeFields Create Date&TimeRange Joiner Table Creator Table Creator Concatenate Row Filter Missing ValueColumn Filter String Manipulation Math Formula Surrogate for Workflow. Remove Dates & RecreateOriginal Data Table. Input Start &End DatesCreates AllDates in Start/EndRange STEP 3Filters 2nd Dayin MonthCreates Factorto Move Weekends& MondaysCreates 2ndWeekday inMonthExtracts NewDateExtratcs New Dayof MonthExtracts CurrentSystem Date.Use in Production.Joins Datesin Table & Current Date.Fails if no Match.Test for Datein TableModel Data(Cannot HaveMissing Data)With Date Match AddsModel DataNode 50Node 51Enter Startand End Date Date RangeGeneration Adding Metadata Row Filter Rule Engine Date&Time Shift Extract Date&TimeFields Extract Date&TimeFields Create Date&TimeRange Joiner Table Creator Table Creator Concatenate Row Filter Missing ValueColumn Filter String Manipulation Math Formula

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: brkyi
Created at: 2022-08-31
On NodePit since: 2023-07-11
Last update: 2024-04-27
Created with KNIME version: v4.7.5
Tags: date timeDate TableDate Table KnimeColumn ExpressionExtract Date Field

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

Try NodePit Runner!