Yes, using two columns ProdSpecialPrice & ProdPriceExpires date sounds like a good idea. I will include them in the tables and Admin backend to control value and date (timestamp). A simple method to set up would be best. Might be good to show regular price and the special price for the product so the customer can see the benifit. Beyond that I am not sure.