You should be able to add to cart page and look up the associated discount for that item and filter to make sure it is in the date range.
Then you could add a column to your cart for itemDiscount and insert the value from the recordset.
After that, create a discount rule to the cart equal to the total of the itemDiscount amounts.