problem about comparing date

I have a problem in this query:

select order from ordertable
where orderdate >= '06/20/2007' and orderdate < '06/20/2007'

this query do not return any record
although there are records in the table matching the query

please help me

Re: problem about comparing date

What possible value can be BOTH >= AND < the SAME date? You need to
add a day to the second date, make it 6/21.

Roy Harvey
Beacon Falls, CT

On Tue, 26 Jun 2007 10:34:51 -0000, "navneetkasulkar@gmail.com"
wrote:

>I have a problem in this query:
>
>select order from ordertable
>where orderdate >= '06/20/2007' and orderdate < '06/20/2007'
>
>this query do not return any record
>although there are records in the table matching the query
>
>please help me

Re: problem about comparing date

Thanx but it was typing mistake
have a nice day

On Jun 26, 4:53 pm, Roy Harvey wrote:
> What possible value can be BOTH >= AND < the SAME date? You need to
> add a day to the second date, make it 6/21.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Tue, 26 Jun 2007 10:34:51 -0000, "navneetkasul...@gmail.com"
>
> wrote:
> >I have a problem in this query:
>
> >select order from ordertable
> >where orderdate >= '06/20/2007' and orderdate < '06/20/2007'
>
> >this query do not return any record
> >although there are records in the table matching the query
>
> >please help me