"John" <joh@mailcity.com> wrote in message
news:ujjkxQCTFHA.2680@tk2msftngp13.phx.gbl...
> why the following two query's results are different... any idea why?
>
> select count(*) from MedicalHistory where CDate between '01/01/2001' and
> '12/31/2001'
>
> 1728066
>
> select count(*) from MedicalHistory where year(CDate) = 2001
>
> 1739088
>
> Thanks in advance....
>
>

John wrote:
> why the following two query's results are different... any idea why?
>
> select count(*) from MedicalHistory where CDate between '01/01/2001'
> and '12/31/2001'
>
> 1728066
>
> select count(*) from MedicalHistory where year(CDate) = 2001
>
> 1739088
>
> Thanks in advance....

"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:OkFGX5CTFHA.2680@tk2msftngp13.phx.gbl...
> John wrote:
> > why the following two query's results are different... any idea why?
> >
> > select count(*) from MedicalHistory where CDate between '01/01/2001'
> > and '12/31/2001'
> >
> > 1728066
> >
> > select count(*) from MedicalHistory where year(CDate) = 2001
> >
> > 1739088
> >
> > Thanks in advance....
>
> Try:
>
> select count(*) from MedicalHistory
> where CDate >= '01/01/2001'
> and CDate < and '01/01/2002'
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com