How to choose folder and file from date as string?

[vignesh.ks]

Hi @fairymemay

For this scenario, do the below steps:

1. Split the date with “/” and assign the arrayofstring to variable.
2. Check whether the folder was exists.
3. If yes, then just write the excel or else, create the folder with year and write the excel.

Attached screen shot for your reference.

In WriteRange activity, give path like this:
your2020FolderPath+"\"+splitingString(2)+"\Report "+splitingString(1)+"."+splitingString(2)+".xlsx"

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation