removing content on a schedule

I have a request from a client to provide a listing of coming events in a sidebar display. This is easy in Power CMS Builder but the kicker is that they want the events to be removed as the date for each event passes and they don't want to have to go back in and manually remove them.

It seems that htere is probably a way to do this using a combination of Power CMS Builder and Data Assist. Is there information I can look at that might help me get this done?

No power cms does not offer way to remove content on a schedule.

I have done this on a site using data assist.

I created a form that allowed a user to add an 'event' including a date. title and description, then used SQL to filter the recordset to only show events in the future.

Im no SQL guru by any stretch of your imagination, but I did something like;

SELECT *
FROM courses
WHERE (courses.start_date >= { fn NOW() })
ORDER BY start_date ASC, courses.`month`

I have then added data assist pages to Power CMS by inserting the forms into a PowerCMS templated page using Framework Builder and edited the Power CMS Menu to show the data assist results page.

It took me a while to figure it out and to get it to look right, but it can be done.