It Worked on Every Environment Except Prod: Getting Daily Reports Right Across Timezones

Every day, a report runs: "what did each store sell yesterday?" One of the stores is in Lagos, the other in London. The report showed both stores as having zero sales for the last two hours of the day