I am getting errors in T-SQL query... Conversion failed when converting datetime from character string. SELECT roA_tblUser.Email as Email FROM roA_tblUser ...

I have a DateTime field ("TheDate") in a SQLServer db that I am trying to sort on/order by. I need only the 'date' portion of the field, however, which isn't tough to pull out, but getting a ...