query problem

Hi <br><br>When I give query<br><br>select * from table where bannerid='"&bannerid&"' and visitordate between '1/1/2003' and '1/26/2003'<br><br>it displays results between the given period<br><br>but when i give query<br><br>select * from table where bannerid='"&bannerid&"' and visitordate between '12/31/2002' and '1/26/2003'<br><br>it displays no records why is this so<br><br>Please help urgently<br><br>thanks in advance<br><br>Uday.

Not sure why your example doesn't work... have you tried using explicit dates (although it shouldn't make much difference in this case)...<br><br>Try - <br><br>select * from table where bannerid='"&bannerid&"' and visitordate between '31 Dec 2002' and '26 Jan 2003'