Icon

Name Excel file with last day of last month

Some dataGet current dateNode 3Convert day ofmonth to negative(to be used asdate shift)Remove thesame amountof days as currentdate will give youlast day of last monthAssign variables hereNode 7Create file namebased on templateand generated dateNode 9Node 10Node 11Create filenameas type PathNode 13Table Creator Create Date&TimeRange Extract Date&TimeFields Math Formula Date&Time Shift Variable Creator Column Filter String Manipulation Extract Date&TimeFields Column Filter Table Rowto Variable String to Path(Variable) Excel Writer Some dataGet current dateNode 3Convert day ofmonth to negative(to be used asdate shift)Remove thesame amountof days as currentdate will give youlast day of last monthAssign variables hereNode 7Create file namebased on templateand generated dateNode 9Node 10Node 11Create filenameas type PathNode 13Table Creator Create Date&TimeRange Extract Date&TimeFields Math Formula Date&Time Shift Variable Creator Column Filter String Manipulation Extract Date&TimeFields Column Filter Table Rowto Variable String to Path(Variable) Excel Writer

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: bruno
Created at: 2022-03-14
On NodePit since: 2022-03-15
Last update: 2024-05-02
Created with KNIME version: v4.5.1

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

Try NodePit Runner!