Comparison

[mike]

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.

 

[Juan Pablo González]

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

 

[Bob Phillips]

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)