Shawn Heisey wrote:
[* TO NOW-2YEARS]^1.0
I also seem to remember seeing something about how to do "less than" in
range queries as well as the "less than or equal to" implied by the
above, but I cannot find it now.
Ranges with square brackets [] are inclusive. Ranges with parens () are
exclusive. And you have a less than example above:
[* TO value] is a 'less than or equal to value' (inclusive)
(* TO value) is a 'less than not including value' (exclusive)
Now, if you want inclusive on one end but exclusive on the other, I'm
pretty sure you're out of luck. :)
Jonathan
