CREATE FUNCTION cal_quarter (@DATE SMALLDATETIME)
RETURNS INT
AS
BEGIN
declare @CalendarQuarter int
IF month(@DATE) in(4,5,6)
BEGIN
set @CalendarQuarter =1
END
if month(@DATE) in(7,8,9)
BEGIN
set @CalendarQuarter =2
END
if month(@DATE) in(10,11,12)
BEGIN
set @CalendarQuarter =3
END
if month(@DATE) in(1,2,3)
BEGIN
set @CalendarQuarter =4
END
return @CalendarQuarter
END
SSRS Reports,Sql server Reporting Services
Tuesday, 10 June 2014
Get Quarters StartDate and EndDate from Year
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment