DATE(CASE
     WHEN HOUR(SUBDATE(CASE
                       WHEN `DCC - Completed w/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 0 THEN `DCC - Completed w/ GIS Drop Error Date`
                       WHEN `DCC - Completed W/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC - Completed w/ GIS Drop Error Date`
                       WHEN `DCC - Completed W/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC Cancelled W GIS Drop Error Date`
                       WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                        AND `Drop Status` = 'Vendor Completed' THEN `Vendor Completed Date`
                       WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                        AND `Drop Status` = 'Completed by Other' THEN `Completed By Other Date`
                       WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                        AND `Drop Status` = 'Cancelled' THEN `Drop Cancelled Date`
                       END,INTERVAL 8 HOUR)) >= 16
     THEN SUBDATE(CASE
                  WHEN `DCC - Completed w/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 0 THEN `DCC - Completed w/ GIS Drop Error Date`
                  WHEN `DCC - Completed W/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC - Completed w/ GIS Drop Error Date`
                  WHEN `DCC - Completed W/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC Cancelled W GIS Drop Error Date`
                  WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                    AND `Drop Status` = 'Vendor Completed' THEN `Vendor Completed Date`
                  WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                    AND `Drop Status` = 'Completed by Other' THEN `Completed By Other Date`
                  WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
                    AND `Drop Status` = 'Cancelled' THEN `Drop Cancelled Date`
                  END,INTERVAL 8 HOUR)
     ELSE (CASE
           WHEN `DCC - Completed w/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 0 THEN `DCC - Completed w/ GIS Drop Error Date`
           WHEN `DCC - Completed W/ GIS Drop Result Error` = 1 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC - Completed w/ GIS Drop Error Date`
           WHEN `DCC - Completed W/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 1 THEN `DCC Cancelled W GIS Drop Error Date`
           WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
            AND `Drop Status` = 'Vendor Completed' THEN `Vendor Completed Date`
           WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
            AND `Drop Status` = 'Completed by Other' THEN `Completed By Other Date`
           WHEN `DCC - Completed w/ GIS Drop Result Error` = 0 AND `DCC Cancelled W GIS Drop Result Error` = 0
            AND `Drop Status` = 'Cancelled' THEN `Drop Cancelled Date`
           END)
     END) AS `Close Date`