Exclude old records according to date in date field

I have a project where we want to have the list automatically exclude records older than 2 weeks from the current date, based on a date field.

Try using the following code in your SQL Statement:

WHERE DATEPART(Wk, YOUR_DATE_FIELD)>=Now()-2