To check against the dates (using coupon_redeem_track), just add something like:
Code:
SELECT COUNT( `crt`.`unique_id` ) AS `uses`
FROM `coupons` AS `c`
LEFT JOIN `coupon_redeem_track` AS `crt` ON `c`.`coupon_id` = `crt`.`coupon_id`
WHERE `c`.`coupon_code` = 'your_coupon_code' AND `crt`.`redeem_date` >= '2013-12-18'