In order to use UNION, the column list for all the SELECTS must be the same (at least in type/length), since it's returning a single resultset; you're basically trying to return both the email and the ...

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 standard ...