Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparison | Excel Discussion (Misc queries) | |||
row comparison | Excel Worksheet Functions | |||
comparison | Excel Worksheet Functions | |||
XLS comparison | Excel Discussion (Misc queries) | |||
Comparison | Excel Worksheet Functions |