Hi
I want to pick up this file from the same folder whenever I want by changing the date
As you can see from below it follows a syntax "FOR101 HKLGL EOD " & YYYY_MM_DD & %
How can I get the file from just choosing the date
File on 14/3/21
FOR101 HKLGL EOD 2021_03_14_014202
File on 16/3/21
FOR101 HKLGL EOD 2021_03_16_034155
File on 17/3/21
FOR101 HKLGL EOD 2021_03_17_034007
I assume you want the current day's file to be processed? Do the previous day's files stay in the folder? I think there are a few options depending on how it's set-up:
Let me know if this is along the lines of what you're looking for. I'm sure others might have other options as well.