Date of Monday by week: sql?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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...