Coupon expiration date -

[motherthemother]

Does it expire at midnight on the day after I set it?

For a labor day sale, if I expire it on Sept 1st, can people use it on that day? Or will it be expired? Do I set the expiration date for Sept 2nd?

[Ajeh]

If I set a coupon for:

Start Date :: 08/29/2008
End Date :: 08/30/2008

At midnight, August 30, 2008 ... as in it was August 29th and I could use the coupon ... then I hit the midnight hour of August 30th ... the coupon would work on the 29th up to midnight and then stop working ...

NOTE: If I am in the checkout and put in the Discount Coupon at:
08/29/2008 11:59pm and am on the checkout_payment page when I do this and go to the checkout_confirmation ... even if I do NOT hit confirm until 08/30/2008 12:01am ... I am valid ...

However, if I leave the checkout after putting in the Discount Coupon at 11:59pm ... and come back to it at 12:01am ... the Discount Coupon is NOT valid ... as I exceeded the time and did not hit confirm checkout ...

[Ajeh]

NOTE: This is based on server time ... so be careful what you wish for ...

It is always a good idea to test these Discount Coupons specifically for what you want based on dates before you need it ...

Example, I want a coupon for 08/31/2008 for 1 day ...

I would test this a few days early, like the 27th and make sure it works properly ...

When that expires, you can COPY to a new coupon and change the dates to the 31st and the new Discount Coupon Code ...

NOTE: the practice Discount Coupon would expire, but the COPY could be updated to the new date ...

[kellan4459]

I have a page that shows the available specials. It is pulling the database expiration date so the customer sees that a coupon expires on the expiration date I have entered into the database.

One option I could modify the date I get from the query before displaying it to the customer. Or I could change the query where I determine if the coupon is expired or not.

My customers thought that the expiration date being set should mean the coupon can be used up to the end of the date specified and in order to not have to explain it each time I have modified the query that checks the expiration to be

$date_query=$db->Execute("
select coupon_expire_date from " . TABLE_COUPONS . " 
where coupon_expire_date >= 
(SELECT DATE_SUB( now( ) , INTERVAL 1 DAY)) 
and coupon_code='" . zen_db_prepare_input($dc_check) . "'");

instead of the original

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

Does anyone see anything wrong with this modification? Or possibly an easier way to achieve the same results?

I have run some tests and it should allow the store owner to enter 2-28 as the expiration and the customer be allowed to use the coupon all day on the 28th so matching some peoples understanding of use ON or BEFORE x date. This may only be important for me based on me not using the sideboxes and displaying the specials differently than most shops but I wanted to throw it out there for discussion.

Thanks