calendar listing recorda matching today forward and limit

Hi there.

Thanks for posting!

I think you are on the right track here but I think it's going to be some more like: date > NOW()

But could you attach a copy of the page you are working with and I'll double check for you? If you could, actually attach it and don't just paste the code in a reply.

Thanks!

I recently did that same thing for listing radio shows. The center of the page lists the upcoming shows and they are automatically moved to the archive list in the sidebar after the broadcast date. Two lists with reverse filters.

list($future_radio_showRecords, $radio_showMetaData) = getRecords(array(
'tableName' => 'radio_show',
'where' => 'hidden="0" and show_date >= (NOW() - INTERVAL 1 DAY)',
));

list($past_radio_showRecords, $radio_showMetaData) = getRecords(array(
'tableName' => 'radio_show',
'orderBy' => 'show_date DESC',
'where' => 'hidden="0" and show_date < (NOW() - INTERVAL 1 DAY)',
));


Hope this helps out.

Hi Ron

Thanks for posting :). Always glad to see everyone helping out :).