Dynamically change folder path using Calendar

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).

Workflow

Interface Tools

Accepted answers

RolandSchubert

Hi @GayatriPanigrahi ,

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

Best,

Roland

ChangeFolder.yxwz

All comments

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

ChangeFolder.yxwz

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 ?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703