Given a start and end date, I was using:
/StartTime >=start and /EndTime<=end. This only takes care of events that start and end within that interval and does not take care of overlapping events, which clearly, should also be counted.
i.e:
t1================================t2
e1|-------------| // works
e2|-------------------------| // error - not selected
e3|-----------------------| // error - not selected
Change logic to:
/StartTime <= end and /EndTime >=start
smh
Given a
startandenddate, I was using:/StartTime >=startand/EndTime<=end. This only takes care of events that start and end within that interval and does not take care of overlapping events, which clearly, should also be counted.i.e:
Change logic to:
/StartTime <= endand/EndTime >=startsmh