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
