Hello!
Does anyone know how how can I automatically create end of months dates that are between two end of month dates? For example, I have these dates: 2023-03-31 and 2023-06-30 and I want to generate a column with all end of month dates in between (in this case, 2024-04-30 and 2024-05-31)?
Thanks!!
Here’s a potential solution:
This is a slight modification of the one proposed in this post:
Hi there @Nanda_Rukmana ,
to add my solution as well (similar to one @ScottF provided already). I decided to use Column Expressions node to determine the first day of previous month.
https://kni.me/w/-KYIGjuZiK3HAOOF
Additionally this seems as a frequent request. Not exactly this one but some kind of date creation/manipulation based on execution point in time. Hopefully we will figure out a way to make this easier in KNIME. Or someone maybe willing to create a Component?
1 Like
@rmonterosapri ,
You can design the workflow as shown in the following image. I have also attached the workflow file for your reference.
KNIME_project.knwf (87.1 KB)
1 Like
system
October 7, 2024, 6:19am
4
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
