I have a page that shows new listings of properties for sale and I order by the date they were listed. Works great except I do not want to see every listing, just the ones for the last 7 days.

SELECT *
FROM for_sale
ORDER BY ListDate Desc

Could someone please help me restrict what can be seen


Thanks

Use the DATEDIFF mysql function. Give this a try:

SELECT * FROM for_sale WHERE DATEDIFF(today(), ListDate) <= 7 ORDER BY ListDate Desc

DATEDIFF always substracts the second term from the first, so be sure you always put the later date (in this case, today()), as the first term otherwise the logic will be off as the result would be a negative number.

On a tangent: That, too, could be solved using some function to determine the absolute value -- but again, the above call should work for you (although I have no means to test it where I am).

Try:

SELECT *
FROM for_sale
WHERE ListDate>=DateAdd("d",-7,Now())
ORDER BY LisrDate DESC;

This seems to work in Access.

Hope it helps!.