This message was deleted.

So if you run the exact same SQL in GrowthBook and the BigQuery console, the end date is off by 7 days? Not sure what could be causing that

yes, thats right

Can you paste in the full SQL? (you can dm me if you have sensitive table names or anything)

I found a mistake. Sorry. May be I didn't realize it bc of UX