For the column “Amount” I need that to display the last day of the month based on the date I run the flow. For example, If I run it today, I need that column to display 11/30/2022
I currently modify it after I write it in an excel file but was wondering if Knime can help me out.
Of course, you can format the date as you want. My locale is en-CA. It (the format) might automatically change for you depending on your locale, or you can manually format the date.
This is how you can get current date, with the Create Date&Time Range node configured like this:
Now, that’s not quite interesting as a test, since it’s already the last day of the current month. To do a real test, I will change that date (only for testing).