DosTips.com

Hello everyone,

I am trying to create a batch file that will essentially look into a specific folder to check for missing files. However, the folder changes everyday and a new folder is created everyday with previous business day (t-1) as the folder name. Hence, I am trying to create a dynamic batch script which will select the folder with the latest date as its folder name. Here is an example of what the path to the folder would look like:
C:\Users\UserA\Ad_Hoc\27Feb2020\Folder_A\File_A

The folder name in bold is what would change everyday and everything else stays consistent. Is there a way to make the path dynamic in terms of the changing folder name?

Thanks!

Hello,

Try using subroutines :jdate and :jdate2date from this very site library of functions:
https://www.dostips.com/DtCodeCmdLib.php#Function.jdate

Ex: I'll leave it to you to convert the numeric month to a string
Also, there's the special case of January 1st that needs to be handled!

user124 wrote: ↑

28 Apr 2020 11:42

a new folder is created everyday with previous business day (t-1) as the folder name. [...]
Here is an example of what the path to the folder would look like:
C:\Users\UserA\Ad_Hoc\27Feb2020\Folder_A\File_A

If you could convince the person or system that creates these folders to use a date format like 2020-02-27 (year-month-day), that would make your life *a lot* easier as this would make these dates sortable.