I just ran across this, it removes the time from a datetime.

DATEADD(d,DATEDIFF(d,0,GETDATE()),0)

...just plug in any date in place of the getdate().