You can also use dateadd as follow(the value parameter could be negative). Try wuth query analizer the follow statement

SELECT GETDATE(), DATEADD(DAY,(-14),GETDATE())

So in your case the statement should be

WHERE date_post BETWEEN...