Icon

25466-v2

Get the beginning of the fiscal year for the year found in the input. Use the day of the week of October 1st of this year to get the first Sunday in October. Use the weeknumber minus one to count further from this fiscal startdate. fiscal year week as yyyywwyearweekas numbersthe datesweek - 1Day of week Oct-01year + Oct01Change to datethe datesdayshiftStartFiscalYearDateThe start dateof the fiscal week Table Creator String Manipulation String Manipulation String To Number Date&Time Shift Math Formula Extract Date&TimeFields String Manipulation String to Date&Time Date&Time Shift Math Formula Column Rename Column Rename Get the beginning of the fiscal year for the year found in the input. Use the day of the week of October 1st of this year to get the first Sunday in October. Use the weeknumber minus one to count further from this fiscal startdate. fiscal year week as yyyywwyearweekas numbersthe datesweek - 1Day of week Oct-01year + Oct01Change to datethe datesdayshiftStartFiscalYearDateThe start dateof the fiscal week Table Creator String Manipulation String Manipulation String To Number Date&Time Shift Math Formula Extract Date&TimeFields String Manipulation String to Date&Time Date&Time Shift Math Formula Column Rename Column Rename

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: in732mel
Created at: 2020-07-24
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.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!