If you have a recurring date and want to calculate the number of days between some dates and the following recurring/custom date, you can use this configurable component.
E.g. if your business year starts on the 1. September and the Date=2022-09-03, then nrDays = 363 and if Date=2018-09-01, then nrDays=365.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!