Comparison
 

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.

Comparison
 

Depends on the data that you're filtering. If you have "whole" days, then,
yes... but if the dates that you're filtering include times, then no.

But, the easiest way is probably just experimenting....

--
Regards,

Juan Pablo González

"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.

Comparison
 

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.