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().