Last year:

(DT_WSTR,4)YEAR(DATEADD("yy",-1,GETDATE()))

Last Quarter:

(DT_WSTR,1)DATEPART("qq",DATEADD("qq",-1,GETDATE()))

This articale is pretty good, but... One point. Almost every time when you load data into clean table without any index) and when you load data into clean table where...