SQL query in ASP

[mavrik_1983]

Hi, I am building a website in ASP and I am using MS SQL server 2005 as my database. My website is for online orders.
What I am now trying to do is to retrive the products from the database which are added within the last 4 weeks.
I dont know how should I go from here onwards in "WHERE" statement. What I want to do is something like this.

SQL = "SELECT *
FROM product
WHERE date_added = (current date minus 4 weeks)

Can anyone help me with this query

Cheers

[Nandem]

SQL = "SELECT *
FROM product
WHERE date_added = DATEADD(DAY, -28, GETDATE())


cya

[Terrorke]

make sure your date_added is of the type date in your database. Otherwise this won't work