ai-automation-consultant / Failure Lab
Python Timezone Drift
A Python cleanup script moves jobs to the wrong service day.
Category
python
Difficulty
standard
Last Run
none
Incident Brief
Diagnose why the exported schedule is off by one day for late-night jobs.
Broken State
The Python script parses local job times as naive UTC datetimes before exporting them to the CRM.
Symptoms
- Jobs after 8 PM local time appear on tomorrow's schedule.
- The raw CSV has the correct local appointment time.
Trace
parsed=2026-08-29T23:30:00Z source_timezone=America/New_York crm_date=2026-08-30 expected_local_date=2026-08-29