Pull Files from Dynamic Folders

[SkyD]

Hello All,

I am trying to pull from two different folders with Today's date, or just the day of the month. Like the below screen shots.

I need to extract the files within the folder's with today's date, and then copy and move the files that are in these dated folders to a general folder that I can then combine all of the excel sheets later on.  

I think I have a general idea of the flow, with a directory tool, an input date, and a CMD tool.  However I'm not sure how to tie it all together. 

Can anyone help?

[aatalai]

You're on the right tracks

use the directory tool to bring the files in, then use a filter to select the relvant fields, then use the cmd tool to write copy (I have not used cmd tool, another way could be the dynamic input tool to bring it in, and then write it as a new output, however you would lose the formatting this way).