Re: Calendar dates returned wrong thru webDAV?

["Lee Derbyshire [MVP]" <email a@t leederbyshire d.0.t c.0.m>]

You will need to remember that appointments in the Exchange store have ther 
dates in GMT.  Make sure that the start and end dates in your query take 
this into account.

Lee.

-- 
___________________________________

Outlook Web Access for PDA and WAP:
www.leederbyshire.com
___________________________________

"JackBlack" <jackisback@xxxxxxxxxxx> wrote in message 
news:%23lV37ii8GHA.2092@xxxxxxxxxxxxxxxxxxxxxxx
> Hi, all!  Accessing Exchange 2k3 via  ASP.Net (WebDAV) on Win2k3 R2 
> Server...
>
> Is there a problem with edited or deleted Calendar items in a public 
> folder showing up in a WebDAV query that DON'T show up in Outlook?  For 
> example, I've got an event being retrieved by WebDAV on one day that 
> doesn't show up in Outlook, and another single event (mutliple days) that 
> is showing up in Outlook as three days (correct: 11/27 thru 11/30)) but 
> the data being retrieved by WebDAV covers five days (11/27 thru 12/1).
>
> Is there an issue with edited or deleted calendar items?  Is there some 
> other flag or field that needs to be taken into account to get the correct 
> days?!!??  WebDAV query at the bottom of post...
>
> Very confused here.  Some single-event multi-day events (not recurring 
> events) work fine, others are just completely wrong (don't match with what 
> I see in Outlook).  Help!!
>
> Thanks,
> Jack
>
>
> **********************************************************
>        strQuery = "<?xml version=""1.0""?>" & _
>                   "<g:searchrequest xmlns:g=""DAV:"">" & _
>                   "<g:sql>SELECT ""urn:schemas:calendar:location"", 
> ""urn:schemas:httpmail:subject"", " & _
>                   """urn:schemas:calendar:dtstart"", 
> ""urn:schemas:calendar:dtend"", " & _
>                   """urn:schemas:httpmail:htmldescription"", " & _
>                   """urn:schemas:calendar:alldayevent"", " & _
>                   """urn:schemas:calendar:busystatus"", 
> ""urn:schemas:calendar:instancetype"" " & _
>                   "FROM Scope('SHALLOW TRAVERSAL OF """ & strCalendarURI & 
> """') " & _
>                   "WHERE NOT ""urn:schemas:calendar:instancetype"" = 1 " & 
> _
>                   "AND ""DAV:contentclass"" = 
> 'urn:content-classes:appointment' " & _
>                   "AND (""urn:schemas:calendar:dtstart"" &gt;= '" & 
> strBuildExDate(dteStart) & "' " & _
>                   "AND ""urn:schemas:calendar:dtstart"" &lt;= '" & 
> strBuildExDate(dteEnd) & "' " & _
>                   ") ORDER BY ""urn:schemas:calendar:dtstart"" ASC" & _
>                   "</g:sql></g:searchrequest>"