Difference in typing in Date Criteria

[LMB]

Hello,

Will these return the same records?

Between [StartDate] And [EndDate]

=[Start Date] And <=[End Date]

Thanks,
Linda

 

[Guest]

Yes it will .. but I prefer the Between method ...

R. Hicks

Hello,

Will these return the same records?

Between [StartDate] And [EndDate]

=[Start Date] And <=[End Date]

Thanks,
Linda

 

[LMB]

Ok...I got to thinking that between could mean the dates in between the
dates I typed in....for instance if I typed in 7/1/05 and 7/31/05, could it
give me records from 7/2 to 7/30 and not include the 7/1 and 7/31....brings
back memories from philosophy class.

Thanks!

Yes it will .. but I prefer the Between method ...

R. Hicks

Hello,

Will these return the same records?

Between [StartDate] And [EndDate]

=[Start Date] And <=[End Date]

Thanks,
Linda

 

[Van T. Dinh]

BETWEEN ... AND ... is inclusive, i.e. end-points are included. Hence it is
the same as >= and <=.