Why don't you declare two variables (@Today and @Tomorrow) and select where date_shipped >= @Today and date_shipped < @Tomorrow

    DECLARE @Today DATETIME
    DECLARE @Tomorrow DATETIME
    
    SET @Today = dateadd(dd, datediff(dd, 0, getdate()), 0)
    SET @Tomorrow = dateadd(dd, datediff(dd, 0, getdate()) +1, 0)
    
    PRINT @Today
    PRINT @Tomorrow

So - after declaring your variables for @Today and @Tomorrow and setting their values accordingly, your `WHERE` clause would be something like this

    WHERE  O.date_shipped >= @Today and O.date_shipped < @Tomorrow