Icon

Find previous working day from work calendar

Sample Date2021-02-07(this would in reality be your "current date" but for testing, I'm returning a specific date)Subtract 1from given datePrevious Daycomparable stringas variable to be used as upper bound in row filterThis is your work calendarFilter work calendarwith max bound beingthe calc'd previous dayPrev dayas a comparable stringin yyyyMMddformatWork_Datesas a comparable stringString in yyyyMMddformatGet the max datefrom the filtered calendarThis is the date you are looking for;-)Create Date&TimeRange Date&Time Shift Table Rowto Variable Table Creator Row Filter Date&Time to String Date&Time to String GroupBy Sample Date2021-02-07(this would in reality be your "current date" but for testing, I'm returning a specific date)Subtract 1from given datePrevious Daycomparable stringas variable to be used as upper bound in row filterThis is your work calendarFilter work calendarwith max bound beingthe calc'd previous dayPrev dayas a comparable stringin yyyyMMddformatWork_Datesas a comparable stringString in yyyyMMddformatGet the max datefrom the filtered calendarThis is the date you are looking for;-)Create Date&TimeRange Date&Time Shift Table Rowto Variable Table Creator Row Filter Date&Time to String Date&Time to String GroupBy

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: @takbb Brian Bates
Created at: 2021-06-21
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.3.3

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

Try NodePit Runner!