What I need to do is to select records withe the date column starting 60 days ago and into the future as far as there are record.

This client Daniel Hinkley Web Site has speaking engagements which currently show all future engagements but we want to also show those for the last sisty days as he wants to show slide lists and notes to the events after the fact!

Sort of like

SELECT *
FROM event_eve
WHERE date_start BETWEEN (CURDATE() -60) AND (>CURDATE())

Nick

-PatP

SELECT *
FROM event_eve
WHERE date_start >= CURRENT_DATE - INTERVAL 60 DAY



pat, you ought to test and see what CURDATE() - 60 actually produces

You could at least make it look hard!

Not so simple, I tried to get just the records from the last sixty days without success.

SELECT *
FROM event_eve
WHERE datestart_eve = CURRENT_DATE - INTERVAL 60 DAY;

Ah yes haz flavr!

never mind.. between cur....

Ah yes haz flavr!

never mind.. between cur....