WordPress redundant posts based on meta field

I ended create another custom post type to manage the schedule and I created a relation to the existing films custom post type:
– Films (all films without tv guide)
– TV schedule (each post represents time in the tv guide and can only be related to one movie). I then enabled future posts to be displayed, this allowed me to use the default post date to so re-arrange the schedule. The default post date also allowed me to expire posts older than 30 days easily.

I plan to write the functionality into a plugin for anyone who might be interested. I will come back and update this.