Well hi guys. How is the best way to get the end of month date ? For example i have a value of 201804. the next steps i do is to add 01 to the end of 201804. So the result is 20180401. The last Step is to count +1 to 04 in the middle of the date. So the result ist 20180501. The last step reduces the date with -1 to the day. The result is 20180430. Anybody knows a easy way to manipulate Dates ? THX Paddy

[image] Paddymaster: The last Step is to count +1 to 04 in the middle of the date. So the result ist 20180501. You may have to think about waht happens if you have a different year in the previous or next month. There are these solutions and discussions about how to determine certain days in month and shift them: [image] Create Date Automatic with Flow Variable KNIME Analytics Platform Hi @Nanda_Rukmana - Here’s an example workflow that should do what you need, based on KNIME nodes only (if you don’t want to use R). [2019-10-31%2012_51_51-KNIME%20Analytics%20Platform] If I run it today (October 31), all the days in September 2019 are returned: [2019-10-31%2012_50_43-Output%20table%20-%202_8%20-%20Create%20Date%26Time%20Range%20(Create%20daily%20range)] [image] Previous Month Dates – ipazin This workflow demonstrates how to create a table with previous month dates based on current month. Logic is contained in Column Expressions node to get first d… [image] Filter on First Business Day of Month – ipazin This workflow filters rows with a due date less than or equal to the first business day of the following month. First business day of the following month is ob…

The Best Way for the end of month

KNIME Analytics Platform

mlauber71 October 9, 2020, 11:05am 2

You may have to think about waht happens if you have a different year in the previous or next month. There are these solutions and discussions about how to determine certain days in month and shift them:

3 Likes

Arithmetic operations for date column