Automatically generating end month dates between 2 end month dates.

Hello!

Does anyone know how how can I automatically create end of months dates that are between two end of month dates? For example, I have these dates: 2023-03-31 and 2023-06-30 and I want to generate a column with all end of month dates in between (in this case, 2024-04-30 and 2024-05-31)?

Thanks!!
Best regards,
Ricardo

Here’s a potential solution:

This is a slight modification of the one proposed in this post:

@rmonterosapri,

You can design the workflow as shown in the following image. I have also attached the workflow file for your reference.

KNIME_project.knwf (87.1 KB)