Icon

forum - Get next reporting date date after a given date

Get date based on weekday

see forum
https://forum.knime.com/t/list-of-reporting-dates-using-first-report-date-cadence-and-flight-start-and-end-date/69428

Quick access toSample Data.xlsxSample Data.xlsxDay of week of First Reporting DayDay of week of Flight End DayCalc Days to next reporting dayAssumes that if reportingdate is the same as end date,then reporting date will be following weekHow many weeks aretherebetween reportingdates?(Weekly=1Bi-Weekly = 2)(report_period)diff in weeks between datesFinal Reporting DateTidy upCalc Days to next reporting dayAssumes that if reportingdate is the same as end date,then reporting date will be same as the end dateFinal Reporting DateTidy upCheck Day of week of Final Reporting DateCheck Day of week of Final Reporting DateOpen File or Folder Excel Reader Extract Date&TimeFields Extract Date&TimeFields Math Formula Rule Engine Date&TimeDifference Column Rename Date&Time Shift Column Filter Math Formula Date&Time Shift Column Filter Extract Date&TimeFields Extract Date&TimeFields Quick access toSample Data.xlsxSample Data.xlsxDay of week of First Reporting DayDay of week of Flight End DayCalc Days to next reporting dayAssumes that if reportingdate is the same as end date,then reporting date will be following weekHow many weeks aretherebetween reportingdates?(Weekly=1Bi-Weekly = 2)(report_period)diff in weeks between datesFinal Reporting DateTidy upCalc Days to next reporting dayAssumes that if reportingdate is the same as end date,then reporting date will be same as the end dateFinal Reporting DateTidy upCheck Day of week of Final Reporting DateCheck Day of week of Final Reporting DateOpen File or Folder Excel Reader Extract Date&TimeFields Extract Date&TimeFields Math Formula Rule Engine Date&TimeDifference Column Rename Date&Time Shift Column Filter Math Formula Date&Time Shift Column Filter Extract Date&TimeFields 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-06-17
On NodePit since: 2023-06-18
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!