I just use knime a few days ago. anyone can suggest me for solve my problem. I want to create date use Create Date&Time Range Node automatically with flow variable. The workflow can be like this.
Report that I do on November, then automatically create date from October,1 - October 31.
Report that I do on December, then automatically create date from November,1 - November 30.
and so on.
here I also show the output what I want.
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.
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?