• Please check this code:

    if exists (select OrderDate from Order) = CONVERT(VARCHAR(20), Getdate(), 101)

    Begin

    ...some code...

    End