Routine~12min

The Gym Membership Charged After Cancellation

Billing support is fielding angry calls — 5 members who cancelled were still charged $49 on the next cycle. The billing job reads member status at the start of the day, so cancellations processed same-day slip through by one extra run. Some members do show a charge on their exact cancellation day, but those charges happened hours before they cancelled — leave those alone.

Tables you'll query

memberscharges

What you'll learn

JOINsDate & Time Functions
Investigate this case →