Dynamically change folder path using Calendar

[GayatriPanigrahi]

Hi All,

I have workflow that is pulling multiple excel files using directory from shared path and the folder structure is dynamic - SharedPath\FolderName\2020\Jun\22\Input\ 

And i want to change the date part available in folder structure i.e. "2020\Jun\22" basis on date selected in Calendar (Interface).

[RolandSchubert]

Hi @GayatriPanigrahi ,

you can use a Date tool and a formula to create the path as needed:

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[GayatriPanigrahi]

Hi @RolandSchubert ,

I am using Directory tool to read files, as i want to read all files available under folder.

Ho do I change Directory path using this ?

[RolandSchubert · Accepted solution]

Hi @GayatriPanigrahi ,

I've modified the workflow a bit. You have to change the directory in the Action tool formula!

Best,

Roland