sql query (last x days)

[Grudge]

It's easy doing a query to get the last x records from the data (they each have a date field)

QUERY : select * from sourcetable order by date limit x

But I need to get the records that were added the last x days ??

 

[rt63]

select *
from sourcetable
where datediff(dd,<date field>,getdate()) >= 8
order by date RT

 

[rt63]

I am sorry. By mistake, I wrote 8 instead of @x

select *
from sourcetable
where datediff(dd,<date field>,getdate()) >= @x
order by date
RT

 

[Grudge]

Thanks, it works 100%