Understanding DateDiff and Case Operator in SQL Queries to Optimize Shipping Status Tracking

Understanding the Peculiar Behavior of SQL Server's DATEDIFF Function When Used with DATEADD