Classic ASP Discussion - Date of Monday by week: sql?

Print Page | Close Window

Date of Monday by week: sql?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=17185
Printed Date: 29 March 2026 at 5:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Date of Monday by week: sql?

Posted By: ub3rl337ch3ch
Subject: Date of Monday by week: sql?
Date Posted: 08 November 2005 at 9:10pm

Ok, is there some way that i can get the date of the monday in a particular week of the year - what is the date of the monday of the third week of this year?

i know i can do it in a vbscript function because i have done it, but is there any way that you can use this within an sql query...

and i know this probably makes no sense at all, but my boss tends not to make sense when she handballs here problems to me...

Replies:

Posted By: michael
Date Posted: 10 November 2005 at 2:32pm

I am using this method to get the monday date of the current week, sorry don't have much time right now to go from there but maybe it's enough as a starter for you

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker