Get date of this week's Saturday

[bjzielinski]

I want to produce a chart that shows each of our systems status and scheduled downtimes. It isn't realtime, I manually enter in data if a system is/will be down for some time. One machine is scheduled down every Saturday morning. I want to produce the date of the coming Saturday from when the script is run. Today (11/06/2002) the result should be 11/09/2002. I thought about getting it from using the week number somehow, but I don't know where to go from there. Any ideas? Bill Zielinski
bzielinski@co.midland.mi.us
County of Midland, Michigan

 

[GabeC]

You can take the number of the day of the week and then add the appropriate number of days to come up with Saturday. This assumes Sunday = 1 and Saturday = 7.

dim nDayOfWeek
'Get the day of the week ordinal.  Sunday = 1, Saturday = 7
nDayOfWeek = weekday(now())
If nDayOfWeek < 7 then
	Response.Write &quot;Saturday is: &quot; & DateAdd(&quot;d&quot;, 7 - nDayOfWeek, now())
else
	Response.Write &quot;Saturday is:&quot; & now()
end if

You will probably want to play with the format of the date to your liking.

Thanks,

Gabe

 

[krisbrixon]

I don't really mess with dates that much.

This web site will help you mess around with the date to figure out what saturday is:

http://www.w3schools.com/vbscript/func_datepart.asp

focus on "firstdayofweek"

Kris

 

[bjzielinski]

Thanks Gabe, worked like a charm. Bill Zielinski
bzielinski@co.midland.mi.us
County of Midland, Michigan