...

View Full Version : weeknumber /days (date)



docock
07-10-2007, 10:11 AM
Hi, how to retrieve the days of the week, if only a weeknumber is given..

for example if someone enters weeknumber 27, how can I retrieve the days:
2-7-2007
3-7-2007
4-7-2007
5-7-2007
6-7-2007
7-7-2007
8-7-2007 ?

Thanks

Daemonspyre
07-10-2007, 01:26 PM
There isn't a specific ASP function to do that for you. You will need to write one.

Basically, start at the beginning of the year and use a DATEADD. You will want to add 7 * (weekNumber) to add the number of days since START_OF_YEAR.


DateAdd("d",7*weekNumber,"1/1/"&year())

* the above code is untested



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum