I am trying to automate the process of manually retrieving documents from a specific folder, the problem is that a part of the path is not fixed, the documents are stored in the sub folder named after the date it was created so the folder path will change depending on the document creation date.
For example the path is \123.123\XYZ\2021\08\23\Pineapple.pdf
\123.123\XYZ\ is fixed
2021\08\23 is the part that changes based on the document creation date
Pineapple is the file name
I do have the document creation date stored in a datatable variable called dtExtract in column M, 20210823. Does anyone know of a way to use the data in column M and assign it to form the full folder path? Any help is greatly appreciated!