Dynamic input folder name

[MarcoBigio]

Hi everyone, I'm building a workflow and I have many different files that are being pulled in from folders with the most recent pay period.

Instead of changing the date for the proper folder multiple times, I was wondering if it's possible to have a date box that gets updated once manually, and then the folders that the workflow pulls would have the correct date. Some of the dates are in the folder name and others are the filename.

Current file path example: \Folder A\03-15-2022\Folder A1\*.csv , \Folder B\03-15-2022\Folder B1\*.csv , \Folder C\FolderD\File03-15-2022.csv

Ideally I'd be able to have one place to replace 3-15-2022 with 3-31-2022.

I've thought about outputting the file path to a column for everything and appending the manually input date, then filtering out the ones where the manually input date doesn't match the date in the file path, but I haven't been able to get that to work. 

Any help would be greatly appreciated!!

[JarekSkudrzyk · Accepted solution]

@MarcoBigio hi, have you tried formula tool and dynamic input?
please see sample attached

[MarcoBigio]

Thank you so much!!

[JarekSkudrzyk]

@MarcoBigio you are welcome:)