SQL date format query

[panini]

I have a query that gets values from todays date or yesterdays date using:

(orderdate = CONVERT(CHAR(8), GETDATE(), 112))

and

(orderdate = CONVERT(CHAR(8), GETDATE()-1, 112))


The cell format used to be 25/12/2006 but it's now been changed to include a timestamp so it's

25/12/2006 10:15:00

Can anyone advice how I change the query to work with the new field?

Many thanks,

 

[panini]

got it guys

(orderdate >= DATEADD([day], - 1, CONVERT(DATETIME, CONVERT(CHAR(8), GETDATE(), 112), 112)))

orderdate >= CONVERT(DATETIME, CONVERT(CHAR(8), GETDATE(), 112), 112)