Routine~13min

The Coupon Used After It Expired

Finance is asking why SPRING20 kept getting applied after its expiry date. 7 orders used it between May 1st and May 2nd — a full day or more after it expired on April 30th at midnight. There's also a batch of WELCOME10 orders that look "late" too, but marketing extended that one's deadline in writing — check the extensions log before you flag it.

Tables you'll query

couponspromotion_extensionsorders

What you'll learn

JOINsDate & Time Functions
Investigate this case →