Pipeline · easy · ~10 min
A new engineer 'simplified' the daily revenue DAG: instead of the templated date it now computes report_date = date.today() - 1 day inside the task. It passed review and worked all week. Then Monday's run failed at 00:30 and was retried at 09:00 — and quietly wrote SUNDAY'S revenue into the wrong slice. A backfill of last month, run Tuesday, was worse: thirty runs all computed the SAME day.
report_date = date.today() - 1 day
Explain the two disasters with one concept.