date based on week number

[guitardave78]

Hi gurus

I have to find the start date of a week (first monday) based on a week number and the year...BUT... it is for an acedemic calendar. SO the first month of the year is august not january!!

any ideas?

 

[Tarwn]

Have you tried using ww for the DateAdd function?
Should be something like:

<%
Dim stDate
stDate = DateSerial(2005,8,1)

'move start date to the next occurence of Monday
stDate = DateAdd("d",(9-WeekDay(stDate)) mod 7,stDate)

'output the dates for the next 5 weeks using DateAdd and "ww" interval
Dim i, enDate
For i = 0 to 5
	enDate = DateAdd("ww",i,stDate)
	Response.Write FormatDateTime(enDate,1) & "<br/>"
Next
%>

Try it out, can't always try my no-the-fly code

-T