I have some queries importing files from the previous day where instead of the date being in the file name it is in the folder before it. For example C:\Programs\090903\FileName.txt.
I have tried to pull it like this..."C:\Programs\"Format(Date()-1,"yymmdd")"\FileName.txt... still to no avail.
I am really clueless on what to do so if anyone has any ideas it would be greatly appreciated
I have tried to pull it like this..."C:\Programs\"Format(Date()-1,"yymmdd")"\FileName.txt... still to no avail.
I am really clueless on what to do so if anyone has any ideas it would be greatly appreciated