_How_ does it "not work"? You haven't told us what you expect .vs. what you get back.
Plus a sample doc that that violates your expectations (just the dateRange field) would also help. Best, Erick On Tue, Nov 22, 2016 at 4:23 AM, Sandeep Khanzode <sandeep_khanz...@yahoo.com.invalid> wrote: > Hi, > I have a simple query that should intersect with dateRange1 and NOT be > contained within dateRange2. I have tried the following options: > > WORKS: > +{!field f=dateRange1 op=Intersects v='[2016-11-22T12:01:00Z TO > 2016-11-22T13:59:00Z]'} +(*:* -{!field f=dateRange2 op=Contains > v='[2016-11-22T12:01:00Z TO 2016-11-22T13:59:00Z]'}) > > > DOES NOT WORK : > {!field f=dateRange1 op=Intersects v='[2016-11-22T12:01:00Z TO > 2016-11-22T13:59:00Z]'} AND (*:* -{!field f=dateRange2 op=Contains > v='[2016-11-22T12:01:00Z TO 2016-11-22T13:59:00Z]'}) > > Why? > > WILL NOT WORK (because of the negative clause at the top level?): > {!field f=dateRange1 op=Intersects v='[2016-11-22T12:01:00Z TO > 2016-11-22T13:59:00Z]'} AND -{!field f=dateRange2 op=Contains > v='[2016-11-22T12:01:00Z TO 2016-11-22T13:59:00Z]'} > > > SRK