I had the same problem so I use the following:

WHERE Convert(varchar(10),date_key,101) Between @Startdate and @EndDate

@Startdate being '10/16/2002'

@EndDate being '10/25/2002'

Edited by - cfeisel on 12/02/2003 10:29:34 AM