Date Transformation

[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

[swapsingh2712]

The workflow which you've provided me earlier, It's working fine when I run those records which contains decommission date.

[afv2688]

lets do it another way, share with me your file with only date values, just a file with that data and I will set it up on my side

Regards

[swapsingh2712]

@afv2688 Thank you for your help, but it seems there's a slight change in our requirement. I'll still need guidance. will post another question in community.

I hope you'd be able to help 🙂