file path with changing folder name

[user124]

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!

[jfl]

Hello,

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

Ex:

Code: Select all

call :jdate TODAY				&:# Get today's day number
set /a "YESTERDAY=TODAY-1"			&:# Get yesterday's day number
call :jdate2date YESTERDAY YEAR MONTH DAY	&:# Get yesterday's year/month/day 

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!

[Eureka!]

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.