Hi @dakoerber
The following workflow can achieve this:
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.
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.
Convert both dates to a variable with the corresponding node to do this. If applicable, convert them to String thereafter with a Variable Expression.
Use a Create D&T Range node to generate the desired range with an interval of P1D whereby the Starting Point and Ending Point are flow variable controlled.
This is off course set under the Flow Variables tab.
With a crossjoiner node you know associate the just created date range again with the employee ID that the group loop still considers.
After closing the loop you’ll up with the individual ranges for each employee
See WF:
Date Range.knwf (35.1 KB)
Hope this helps!