What happened

An analysis labeled one date was run three days later.

Run date first; use CURRENT_DATE() in SQL.

Build the lesson into your workflow.