Hi,
I need a bit of help with a complex batch file i am TRYING to create on Windows 2000 (and hopefully it will work on XP as well...but that's an ideal, not a requirement)

Basically i have a Jscript i want to convert to a batch file to calculate the date from the last defined day of the last 7 days. I will paste the Jscript info at the end of the post for you to get a better understanding of what i am trying to do.

For eg the script will: get date of last Monday (or other days), show in format DDMMYY or YYMMDD or even MMDDYYYY (must be able to be adapted for each situation) and then use that calculation as part of a command.

I am using wget (and other programs) to download files on a daily basis that have the date as part of their file name. So i need the date of the day i specfy to be included in that command. For eg: http://www.somesite.com/files/file290606.ext

However i may need to download files dated on Monday only made available later in the week. So for eg today might be 29/06/06 (or any date up to 7 days past the file date) but i need a file from Monday which might be 260606.
* Please note I cannot calculate from "X" days ago as the day i download the files will vary.

Here is the Jscript i have been using which should help you understand what i am talking about:


Quote

function getDateOfLastWeekday(weekday){
var date=new Date() // Get current date
var difference=0 // Set the difference between the date we want and today
if(date.getDay()<weekday){ // Has the desired weekday passed?
difference=7-(weekday-date.getDay()) // Yes, figure out how many days ago that that weekday occurred.
}
else{
difference=date.getDay()-weekday // No, figure out in how many days it will occur.
}
new_date=new Date(date.getTime()-difference*86400000) // Make a new date by removing 86400000 milliseconds for each day from today's date.
new_year=new_date.getYear().toString().substring() // Get the year, convert to string and remove first two numbers
new_month=new String((new_date.getMonth()+1)) // Get the month, convert to string
if(new_month.length==1){new_month="0"+new_month} // Prepend a 0 if neccessary
new_day=new_date.getDate().toString() // Get the day, convert to string
if(new_day.length==1){new_day="0"+new_day} // Prepend a 0 if neccessary
return new_year+new_month+new_day // Smack it all together in one big string and send it back to whoever asked!
}

var Shell = new ActiveXObject("WScript.Shell");
Shell.Run("http://www.somesite.com/files/file"+getDateOfLastWeekday(6)+".ext");

// It takes an integer between 0 and 6 as an argument (above 6 is accepted but might give incorrect results).
// 0 is Sunday, 1 is Monday, ..., and 6 is Saturday.
// It returns the date of the previous weekday that matches the argument in the form of ddmmyy.

// So you could do:
// Shell.Run("mms://somewebsite/"+getDateOfLastWeekday(3)+".wmv");

Thanks for all the work you have done Dilbert. It's much appreciated.

I tested the script and it came back with :A week ago, it was day 31 of May, 2006."
I'm in Australia so the date today is Thursday 06/07/2006.

A week ago, it was day 28 of Jun, 2006.

"jscript seems to run straight through its commands without waiting for any process or command to finish first"