开发者

vbscript asp - Find every Thursday in a given month

开发者 https://www.devze.com 2023-03-31 18:45 出处:网络
I开发者_如何转开发\'m trying to find all Thursdays within a given Month using VBScript. Can anyone help?Here is one way;

I开发者_如何转开发'm trying to find all Thursdays within a given Month using VBScript.

Can anyone help?


Here is one way;

base_date = cdate("21 aug 2011")

'get 1st thursday;
thurs = dateserial(year(base_date), month(base_date), 1)
if (weekday(thurs) <> 1) then thurs = 5 - weekday(thurs) + thurs

'loop subsequent;
do until month(thurs) <> month(base_date)
    msgbox thurs
    thurs = dateadd("d", 7, thurs)
loop


While the accepted answer does the job it's overly complicated for something that can be accomplished with WeekDay() function and a For loop.

Dim day
Dim startdate: startdate = CDate("21 aug 2011")
Dim enddate
'Get first day of month.
startdate = DateSerial(Year(startdate), Month(startdate), 1)
'Get last day of month.
enddate = DateAdd("m", 1, startdate) - 1
For day = startdate To enddate
  If WeekDay(day) = vbThursday Then WScript.Echo day & " = " & WeekDayName(WeekDay(day))
Next

Output:

04/08/2011 = Thursday
11/08/2011 = Thursday
18/08/2011 = Thursday
25/08/2011 = Thursday

Any Date and Time constant can be used here to look for different or multiple weekdays with a little tinkering.

0

精彩评论

暂无评论...
验证码 换一张
取 消