Icon

Dates to Periods based on cutoff day

Dates to Periods based on Cutoff

Determine periods for a given date based on cut-off where 26th of the month is the "next" period.

Sample Dates as stringsMake into actual datesIs day >=26 ?if so,we need to add1 to the monthAdd monthConvert to a period stringMMM-yyformatTidy upTidy upget day of monthTable Creator String to Date&Time Rule Engine Date&Time Shift Date&Time to String Column Filter Column Rename Extract Date&TimeFields Sample Dates as stringsMake into actual datesIs day >=26 ?if so,we need to add1 to the monthAdd monthConvert to a period stringMMM-yyformatTidy upTidy upget day of monthTable Creator String to Date&Time Rule Engine Date&Time Shift Date&Time to String Column Filter Column Rename Extract Date&TimeFields

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: bbate
Created at: 2023-07-05
On NodePit since: 2023-07-05
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!