Icon

2019_​11_​04_​Previous_​Month_​Dates

Previous Month Dates
Previous Month DatesThis workflow demonstrates how to create a table with previous month dates based on current month. Logic iscontained in Column Expressions node to get first day of previous month and then Date&Time Shift node is usedd withduration to get last day of previous month.Forum link: https://forum.knime.com/t/create-date-automatic-with-flow-variable/19173 Get execution dateGet current monthApply logic to get first day of previous monthShift in order to get last day of previous monthCreate flow variablesCreate dates for previous month Create Date&TimeRange Extract Date&TimeFields Column Expressions Date&Time Shift Table Rowto Variable Create Date&TimeRange Previous Month DatesThis workflow demonstrates how to create a table with previous month dates based on current month. Logic iscontained in Column Expressions node to get first day of previous month and then Date&Time Shift node is usedd withduration to get last day of previous month.Forum link: https://forum.knime.com/t/create-date-automatic-with-flow-variable/19173 Get execution dateGet current monthApply logic to get first day of previous monthShift in order to get last day of previous monthCreate flow variablesCreate dates for previous month Create Date&TimeRange Extract Date&TimeFields Column Expressions Date&Time Shift Table Rowto Variable Create Date&TimeRange

Nodes

Extensions

Links