Time zone for Discount code expiration

[RussR]

My zencart site is hosted on an East coast server but my customers are on Pacific Time. Is there any way to have my discount codes expire at midnight Pacific time instead of 3 hours earlier in Eastern time? I can't find any options for an expiration time - only a date.

[Ajeh]

I have not tested this, but you could try changing ot_coupon.php to use:

        $date_query=$db->Execute("select coupon_expire_date from " . TABLE_COUPONS . "
                                  where coupon_expire_date >= now() + INTERVAL 3 HOUR and
                                  coupon_code='" . zen_db_prepare_input($dc_check) . "'");

I have not tried it, but you can see if this can accomplish what you need ...