And another quick tip for SQL. Sometimes we need to remove TIME part from DATETIME. For example need to group by date or so. You know your needs better.
Here is my solution.
DATEADD(day, DATEDIFF(day, '20000101', RecDate), '20000101')
I saw some freaky CASTs and I don't like these. This returns DateTime type, not string.