Hello people
I found couple of solutions for getting the last day of the month, but they were always done to get last day of the PREVIOUS or NEXT month from the column, I need the last day of the CURRENT month in my column. I tried some things but none of them worked as they should…so any help would be very much appreciated
Example:
date in column 14.04.2020.
what I need: 30.04.2020.
Kind regards,
1 Like
If you can use Python try this
Last month day.knwf (6.7 KB)
1 Like
There was a thread about this
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?
2 Likes
amazing solution! simple and fast but I wanted to find more “KNIMEish” solution for this problem.
@pigreco
system
May 21, 2020, 10:37am
8
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
