What I'm looking to do will probably take some custom programming. i'm looking for advice about where I can begin . . .

I would like to create a category called 'Deal of the Day' where I could have a daily special. It would only show 1 item, which would show for a 24 hour period, and then it would switch to the next Deal.

I know you can specify dates at which products are available and you can also specify the dates of specials. The pieces are there, just not sure how to put it together.

Thanks.