try this query :
TimeSpan ts= new TimeSpan(1,0,0,0)
"select * from test_table where [DATE] < "'+System.DateTime.Now.ToShortDateString()+'" and [DATE] > "'+System.DateTime.Now.Subtract(ts).ToShortDateString()+'""
now you can subtract day values as much you want.