Slideshow with a deadline

[Saraaa]

Hello, 

I have a slideshow in my template, when there's a new promo of  product I put a slide for it in the home page 

I always have so many slides of products in promo and each promo have a diffrent dead line and because of that i spent so much time checking what promo periode is over and I delete the slide 

I want to automate this function, I want to be able to put the date of the promotion when I insert the slide and it will automatically be disactivated when the promo is over.

I thought to do it using a trigger in the database but i couldn't.

Any ideas??? or is ther a module that can do it for me?