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
Solved! Go to Solution.
The workflow which you've provided me earlier, It's working fine when I run those records which contains decommission date.
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
@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 🙂