By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,558 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,558 IT Pros & Developers. It's quick & easy.

Get Start + End Date of a given Week number

P: n/a
Hello, How do I get the start date, and end date of a given week
example, Week 20, year 2004.
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Nick,
Just a thought, you could try something like:

Dim datDatum as date
Dim intWkNo as integer
datDatum = DateSerial(Year(Now), 1, 1)

Do while Day(datDatum)<>"Mon"

DateAdd(DateInterval.Day,1,datDatum)

Loop

StartDate=DateAdd(DateInterval.WeekOfYear, intWkNo, datDatum)

Doug

"Nick Chan" <zz*******@yahoo.com> wrote in message
news:cf*************************@posting.google.co m...
Hello, How do I get the start date, and end date of a given week
example, Week 20, year 2004.

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.