Hi All,

I need yr help !
my sql :

select * from mydb WHERE c_date >= #textbox1# AND c_date <= #textbox2#

I need to filter record base on date and time like this;
Exp : textbox1 : 02/26/2006 07:00:00 AND textbox2 : 02/26/2006 19:00:00 ( this one OK)
but facing problem with this : textbox1 : 02/26/2006 19:00:00 AND textbox2 : 02/27/2006 07:00:00- record not found.

Anybody can help.?

Thanks
Jai

use

select * from yourdb where c_date between #textbox1 and #textbox2

If it shows no record found. Dat means that this date doesn't exist.