Keep it simple...DECLARE@Sample TABLE

(

theDate DATETIME NOT NULL

);

INSERT@Sample

(

theDate

)

SELECTDATEADD(DAY, Number, '20130101')

FROMmaster.dbo.spt_values

WHERE[Type] = 'P';

-- SwePeso

SELECTtheDate,

DATEPART(YEAR, DATEADD(MONTH, -3, theDate)) AS FiscalYear,

(DATEPART(DAYOFYEAR, DATEADD(MONTH, -3, theDate)) + 6) / 7 AS FiscalWeek

FROM@Sample

ORDER BYtheDate;