Okay so If I do...
SELECT * from orders
the 'OrderDate' column is formatted like '2007-03-28 16:29:35.000'
but if I do
SELECT * from Orders where OrderDate = '2007-03-28' then nothing is displayed.
What I ultimatley want is to do
SELECT * from Orders where OrderDate = DATEADD(day, -1, GETDATE())
But no results are returned even if there is data there.
Please somone help. Need this workin for tonight.