if exists (select OrderDate from Order where OrderDate = CAST(Getdate() AS DATE))

Begin

...some code...

End

Note with this code, the if check will evaluate to true if any value of OrderDate in the table is today - is that the desired behaviour?

Cheers

Gaz