Filter first date of every month between a date range

KNIME Analytics Platform
1

Hi
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?

2

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?

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.