How to get the quarter of the year from a date parameter
Declare @AsOfDate Date='04/30/2013' Select Cast(((MONTH(@AsOfDate)-1)/3) as int)+1 as Quarter --or SELECT DATENAME(quarter, @AsOfDate)
Declare @AsOfDate Date='04/30/2013' Select Cast(((MONTH(@AsOfDate)-1)/3) as int)+1 as Quarter --or SELECT DATENAME(quarter, @AsOfDate)