T-SQL: Get the Week Number for a Given Month

Syndication

RSS
Atom
Comments RSS
Receive Email Updates
Subscribe

by David Leibowitz | December 11, 2007 | Comments: 1

This function is fairly simple. Pass in a date and we return the Week # of the month. Generally this is 1 -5. In a rare case, like April 2006, this may stretch to 6. It can be customized for custom calendars.

declare @p_date smalldatetime
set @p_date = '5/15/2007' --or any date you like

select datediff(wk, cast(cast(datepart(mm,@p_date) as nvarchar(2)) + '/01/' + cast(datepart(yyyy,@p_date) as nvarchar(4)) as smalldatetime),@p_date) +1

In this case, the result would be 3.