Icon

76197-Get First and Last Day of Month from String

This workflow is related to a question of frepez over at the KNIME forums

This workflow is related to a question of frepez over at the KNIME forums:https://forum.knime.com/t/create-a-lsrt-day-month-from-an-text/76197 Last Day of Month Calculation First Day of Month Calculation importbase tableconvert string to date and timeconvertFavis > strselectedmth +1get only thedays numberday of monthas negativenumbersubtractdays fromoriginal datere-calculatedays of monthfor1st day of monthsubtractdays fromoriginal datetidy upcols Excel Reader String to Date&Time Number To String Date&Time Shift Extract Date&TimeFields Math Formula Date&Time Shift Math Formula Date&Time Shift Column Filter This workflow is related to a question of frepez over at the KNIME forums:https://forum.knime.com/t/create-a-lsrt-day-month-from-an-text/76197 Last Day of Month Calculation First Day of Month Calculation importbase tableconvert string to date and timeconvertFavis > strselectedmth +1get only thedays numberday of monthas negativenumbersubtractdays fromoriginal datere-calculatedays of monthfor1st day of monthsubtractdays fromoriginal datetidy upcols Excel Reader String to Date&Time Number To String Date&Time Shift Extract Date&TimeFields Math Formula Date&Time Shift Math Formula Date&Time Shift Column Filter

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: m1pegv
Created at: 2023-12-22
On NodePit since: 2023-12-22
Last update: 2024-05-01
Created with KNIME version: v4.6.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!