Windows & DOS: Issues & Discussions

Hi,
Let me clarify

I have a dos batch file which processes a text file and generates a .csv output file. I want to append the next Saturday date to the output file name.
Right now I am able to append the current date by using the below mentioned logic

Code:

set Pdate=%date:~10,4%%date:~4,2%%date:~7,2% {setting current date to variable}
-outputFile %OUTDIR%\AglItemMaster_"%PDATE%".csv

now I want to pass next saturday date in place of current date.
Kindly help.
A quick response will be really helpful.

---------- Post updated at 01:51 AM ---------- Previous update was at 01:46 AM ----------

Hi,
Let me clarify

I have a dos batch file which processes a text file and generates a .csv output file. I want to append the next Saturday date to the output file name.
Right now I am able to append the current date by using the below mentioned logic

set Pdate=%date:~10,4%%date:~4,2%%date:~7,2% {setting current date to variable}
-outputFile %OUTDIR%\AglItemMaster_"%PDATE%".csv

now I want to pass next saturday date in place of current date.
A quick response will be really helpful.
Thanks in advance.

Sorry, I don't know any quick dodge in Windows to calculate "next Saturday's date". You already have the YYYY, MM, DD values needed to seed the calculation but not today's day of the week.



Btw Your date format in %date% must be quite different from mine.
Mine is in the format "dd/mm/yyyy" (10 characters).
Therefore yyyymmdd=%date:~6,4%%date:~3,2%%date:~0,2%

Thanks a lot all for all you support. I got this solution from the internet

Code:

@echo off
>NextSat.vbs echo wscript.echo FormatDateTime(Date + (7 - Weekday(Date)))
For /f "delims=" %%D in ('cscript //nologo NextSat.vbs') do set nextsaturday=%%D
del NextSat.vbs


echo Next Saturday Is %Nextsaturday% :b:

or

Code:

@echo off
>#.vbs echo wsh.echo "Set Nextsaturday="^&dateAdd("d",7-Weekday(Date),date)
for /f "delims=" %%_ in ('cscript /nologo #.vbs') do %%_
del #.vbs

set Nextsaturday