I have an excel file which has a start date and end date in Cell A1 and A2 respectively (1/1/2015 and 1/9/2019)
After importing the excel in knime I want in a New Column to be created extracting only the first date of every month which lies between the start and end date stated above.
I know how to do it using string manipulation and row filter, however is there a better way?
Hi @MelroyFerreira and welcome to the forum.
Have you tried feeding your imported date values as flow variable to the Create Date&Time Range node?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.