First day of one week
select DATEADD(wk,DATEDIFF(wk,0,@DynamicDate), 0) as CurrentWeek
First day of one month
select DATEADD(mm,DATEDIFF(mm,0,@DynamicDate), 0) as CurrentMonth
First day of one quarter
select DATEADD(qq,DATEDIFF(qq,0,@DynamicDate), 0) asCurrentQuarter
First day of one halfYear
Select DATEADD(qq,2,DATEADD(yy, DATEDIFF(yy,0,@DynamicDate), 0))CurrentHalfYear
First day of one year
select DATEADD(yy,DATEDIFF(yy,0,@DynamicDate), 0) as CurrentYear