A retention query can pass and still count the wrong week

“Active in days 8–14” looks precise until two queries disagree at midnight. Before comparing retention rates, I check three things: the time interval, the observation window, and whether the event exp