I’d like to create a column using a start month and the number of month, but have no idea how to do this.
the input is like this:
**id |start month| # of month
01 | 01-01-2020 | 8
the expected output is:
01 | 01-01-2020
02 | 01-02-2020
03 | 01-03-2020
04 | 01-04-2020
05 | 01-05-2020
06 | 01-06-2020
07 | 01-07-2020
08 | 01-08-2020
Thanks in advance
Hi @JoshuaOvO and welcome to the Knime Community.
You can use the Create Date&Time Range node to do this.
Here’s a quick workflow I put together:
Here’s the workflow:
Generate dates based on start date and number of month.knwf (16.3 KB)
Note: The date format depends on your locale settings, and mine is set as yyyy-MM-dd. If your locale settings is set such that it’s dd-MM-yyyy, it should automatically display the same way as what you showed as output. If it does not, and you really want to force the display to be dd-MM-yyyy, and you are struggling with this, let me know and I can add that part too.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.