hi i have two dates in my table, 03-23-2007 8:00:00 03-24-2007 8:00:00 I have two dropdown in my page use to filter between those two dates. i used to convert the two dates into CHAR CONVERT(CHAR(10),date,110) so the result is just "03/23/2007" and "03/24/2007" but the problem now is, when i filter the date like SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/23/2007' returns no value but if my query is like : SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/24/2007' it returs value but only the rows with the date '03/23/2007'. Any idea about that? Bernie