cannot get the "if today is after....if today is before.." working
Hi there I have set up a coupon system on the checkout page. There will be many variations of rules governing the type of coupon. However as soon as I give a rule the following triggers, the coupon wont work.
"If today is after CouponValidFrom"
"If today is before CouponValidTo"
I will provide a screen shot og the rules, Im using. and the checkout page in the zip file.
In the database table the fields that store the dates From/To are DATE (should it be DATETIME? for this rule to function?) In the admin I am storing the data as DATE
I have setup a recordset to filter the coupon code and I have set all the sessions.
Any idea why it wotn work once I use the "if today..." rules??
Chris