>>MartinaJ
>
>Thank you. Your code is even shorter than mine using DATEADD().
Your code should never be used in production as it's non-sargable. Using CAST(dateTimeColun as date)
is OK.
Or you can use what Michel suggested, it's a proven approach.
If it's not broken, fix it until it is.
My Blog 
