Need to divide the date range

[swapsingh2712]

Hello All,

I've a data set where for a particular test, there's an activation date  and decommision date columns. I want to transform that data set into a new file where it shows all the dates that are mentioned between  activation date  and decommision date columns in one column. The format should be in mm/dd/yyyy format.

For example if the activation date is 1/1/2018 and decommission date is 8/30/2018. the new transformed column should show dates like this

1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018

I've attached the screenshot for better understanding

Could you please help

BR,

swapsingh

[Joe_Lipski]

You need the Generate Rows tool for this task!

I've attached a workflow which hopefully solves your challenge:

[binuacs]

@swapsingh2712  another method to generate the dates

[NeilParrott]

Here's another suggestion.

I add in a record ID for the instance where multiple date lines are added and reviewed at once. Included in the workflow is 3 different result options to consider.

Enjoy!