>>>>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.
>
>non-sargable? En ingles, por favor :)

Can't be promoted into a sergeant.