>>Because the field is datetime and not the date <g> You don't have DATE fields in SQL Server.
>
>Thank you for clarifying. (I knew my question was stupid <g>).
No, it is fine. There was an idea of adding a DATE field to SQL Server 2005 dropped somehow...
If it's not broken, fix it until it is.
My Blog