Looping to create date range for fiscal month

[GNMC]

Hello, using 4.7.8 here:

I get this error: “ERROR Create Date&Time Range 3:5 Execute failed: Cannot invoke “Object.getClass()” because the return value of “org.knime.time.util.SettingsModelDateTime.getSelectedDateTime()” is null”

I am trying to append a date range for every row in a table that has a Fiscal Month start and end date by using them as variables in a loop going one row at a time.

The end result I am looking to achieve is this:

I can execute only the cross-joiner node and it produces one fiscal month of dates no problem, but when executing the loop it fails with the message above!

Any help is greatly appreciated - thank you!

[ArjenEX]

Hi @GNMC

It’s hard to diagnose with just this image. I have a suspicion that a variable is empty.
I see your values being of type date but the Create DT range nodes has to work with strings.

I have just posted a solution on a very similar use case. Maybe it can also help you out.

Date Range

Hi @dakoerber The following workflow can achieve this: [image] For the sake of assumption, I created a dummy table whereby the dates are of type date in the format that is required later on. If it’s already of type string you can skip a later step. [image] Since the date range has to be determined per employee ID, you start with a group loop. This now only considers the dates for each employee. [image] Convert both dates to a variable with the corresponding node to do this. If applicabl…