Date for Monday and Friday of Current Weekhttp://wardyit.com/blog/blog/archive/2005/11/02/51.aspxThe Date for Monday and Friday of the current week can be determined as illustrated below. SELECT GETDATE() + (2 - DATEPART(WEEKDAY, GETDATE())) AS MONDAY, GETDATE() + (6 - DATEPART(WEEKDAY, GETDATE())) AS FRIDAY This assumes that you consider t he firstenCommunityServer 2.1 SP1 (Build: 61025.2)Select Date Name from Day &laquo; Huynhvothinh&#8217;s Webloghttp://wardyit.com/blog/blog/archive/2005/11/02/51.aspx#11212Mon, 16 Mar 2009 08:32:51 GMTa571ac07-9c60-4a47-9a5c-9bf2382f2f8e:11212Select Date Name from Day « Huynhvothinh’s Weblog<p>PingBack from <a rel="nofollow" target="_new" href="http://huynhvothinh.wordpress.com/2009/03/16/select-date-name-from-day/">http://huynhvothinh.wordpress.com/2009/03/16/select-date-name-from-day/</a></p>