T
Tadwick
Could someone please confirm the following. If you want to find all
appointments between two dates StartRange and EndRange you can restrict the
items collection using a filter as in :
strFilter = "([End] > '" + Format(StartRange, "mmmm dd, yyyy") + " ' AND
[Start] < '" + Format(EndRange, "mmmm dd, yyyy") + "') "
Set oItms = oItms.Restrict(strFilter)
However, to be rigorous you need to find all exceptions that fall inside
your range. The problem is that you cannot rely on the above filter to
capture those exceptions as the recurrence pattern may specify dates outside
the range but one or more exceptions may be inside the range.
So the solution seems to be either set IncludeRecurrences to True and take a
performance hit or get the recurrence pattern for all items and check all the
exceptions for dates in the range.
Is this correct?
Thanks, Tad
appointments between two dates StartRange and EndRange you can restrict the
items collection using a filter as in :
strFilter = "([End] > '" + Format(StartRange, "mmmm dd, yyyy") + " ' AND
[Start] < '" + Format(EndRange, "mmmm dd, yyyy") + "') "
Set oItms = oItms.Restrict(strFilter)
However, to be rigorous you need to find all exceptions that fall inside
your range. The problem is that you cannot rely on the above filter to
capture those exceptions as the recurrence pattern may specify dates outside
the range but one or more exceptions may be inside the range.
So the solution seems to be either set IncludeRecurrences to True and take a
performance hit or get the recurrence pattern for all items and check all the
exceptions for dates in the range.
Is this correct?
Thanks, Tad