Another date compare question

Hi Dave,

Mine too, but I think that I've got it working now.

Here's the 'where' that I used to show reception_ dates for the upcoming week, as you suggested.

'where' => '(NOW() + INTERVAL 7 DAY) >= reception_date AND reception_date >= TIMESTAMP(CURDATE(), "00:00:00")',

And here's the 'where' that I used to show all the other events (and leave out those already listed)

'where' => 'reception_date <= TIMESTAMP(NOW()) OR reception_date >= TIMESTAMP(NOW()+ INTERVAL 7 DAY)',

I'm still a little (lot) shaky about where to use CURDATE, NOW, TIMESTAMP and the 00:00:00, but I'll play some more and make sure that it works.

If you see something I've missed (without making your head hurt too much), please let me know.

One more question.

In my list viewer, I've repeated the entire page code twice, once for each set of 'where' conditions, and then changed the body code in each to suit. Is there a more elegant way to code this then repeating all of the code twice.

Thanks again and again for all you do.

Jerry Kornbluth