date less x days in SQL[resolved]

[thebloke]

Guys,

I'm sure this is straightforward enough but my brain hurts at the moment.

I want to run a query that gives me data for the last 7 days/month or whatever.

So I need to do something like:

select * from tblcounterv3
where countdate between ('a date a month ago' and convert(varchar,getdate(),103)

It's the 'a date a month ago' that I don't know how to work out.

Hope this makes some sense!

Cheers


Peter