View Single Post
  #2  
Old April 19th 07, 04:11 PM posted to microsoft.public.outlook.program_addins
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default How to get all events for a perticular date, (need exact filter)

When you add a filter to a Table object you are dealing with raw MAPI
properties, not Outlook properties that have been massaged to show local
time. You must use UTC times with tables in all cases. So do any of those
dates when compensated for local time still return items that are out of
your filter range?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


wrote in message
s.com...
Hi,

In the Outlook Instant search using Folder.GetTable() method, we found
that while filtering the calendar events for a particular date it is
giving all calendar events for that date plus all recurring items even
if not on that date ( i.e. if we have recurring meeting say weekly
meeting on Monday and we are firing query on Tuesday's date to get
calendar events then we are getting all events on that Tuesday's date
plus the recurring meeting on Monday which occurrence is not on
Tuesday's date). These problems are with the Weekly, Monthly and
Yearly calendar items.

So to get exact result which filters we will need to use in the
Folder.GetTable() method??

I am using following filter :
@SQL=(
(
(
(urn:schemas:calendar:dtstart = '12:00 AM, 04/18/2007')
&
(urn:schemas:calendar:dtstart '12:00 AM,04/19/2007')
)
|
(
(urn:schemas:calendar:dtend '12:00 AM, 04/18/2007')
&
(urn:schemas:calendar:dtend = '12:00 AM,04/19/2007')
)
)
)


Please help ..

Thanks in advance


Ads