How do I pull records for the current year using the system date?

Did you need records between 1 April to 31 March.

All of current year up til today.

It means, suppose todays u need records from 1 jan 2011 to 5 april 2011.

Use GETDATE()


select * from yourtable
where DATEPART(YEAR, yourdatefield) = DATEPART(YEAR, GETDATE())

Thank you.

try this one...
select * From T_table
where d_column between convert( datetime , convert(char(4),year(getdate())) +'-'+ convert(char(4), '1')+'-' + convert(char(4),'1') )
      and convert( datetime , convert(char(4),year( getdate())) +'-'+ convert(char(4),month( getdate()))+'-' + convert(char(4),day( getdate())) )