• Thanks!

    I will test those solutions tomorrow at work. I also just read through a book and got this solution as well....

    convert(datetime, convert(varchar(10), chargedate, 112))

    The inner conversion would strip out the time portion, the outer conversion would convert the string back into a date format with all zeros in the time portion (midnight).