Datetime Conversion error

Can you try the below statement ?

;WITH WCTE AS(
        Select  Header, Convert(DateTime,Value,110) ServiceDate2
         from tblUdrElement
        Where 1=1 and Header = 'Service Date'  
)SELECT * FROM WCTE
where ServiceDate2 >= '2012-01-01'
order by 1
-----------------
or
-----------------
;WITH WCTE AS(
        Select  Header, Value as ServiceDate2
         from tblUdrElement
        Where 1=1 and Header = 'Service Date'  
)SELECT * FROM WCTE
where ServiceDate2 >= '2012-01-01 00:00:00.000'
order by 1

---

Regards, RSingh