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