Can anybody help me in retrieving the data from specified date to 30 days ago in sql. I tried using [date] >= dateadd(d,datediff(d,0,'2011-03-28'),-30),, but its retrieving records till current date. I want to retrieve data only till 28 march from 30 days ago i.e. 28 Feb or 1st march.

Welcome for all suggestions

WHERE datetimecolumn BETWEEN DATEADD(D,-30,'2011-03-28') AND '2011-03-28'

Ya. It worked well. Thank you