Mike,

Between is open to interpretation IMO, it can be read as the space which
separates, which doesn't include, or it can be read as belonging to both.
Because of this, I feel it is best avoided, the second form is unambiguous.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mike" wrote in message
...
Will the following criteria produce the same results?

(1) Date Field is between 9/11/01 and 5/5/03

(2) Date Field is greater than 9/10/01 and less than
5/6/03?

Thanks.