Looping to create date range for fiscal month

[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…