|
|
|
date: 19 Mar 2006 23:33:58 -0800,
group: microsoft.public.exchange2000.development
back
Re: All day event not returned by query
Hello,
one common issue here is the used timezone. Exchange stores all time
settings in GMT. If you are living in a timezone of -5 hours, outlook will
adjust the calendar fields with this. This will result in the time field
having a value of '2006/03/26 19:00:00'.
You must adjust your query accordingly.
Greetings,
Henning Krause [MVP]
wrote in message
news:1142840038.597665.103730@g10g2000cwb.googlegroups.com...
> Hello,
>
> I'm using the following statement to query my calendar:
>
> SELECT "urn:schemas:httpmail:subject", "urn:schemas:calendar:location",
> "urn:schemas:calendar:dtstart", "urn:schemas:calendar:dtend",
> "urn:schemas:calendar:alldayevent", "urn:schemas:calendar:instancetype"
> FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
> "urn:schemas:calendar:dtstart" >= '2006/03/27 00:00:00' AND
> "urn:schemas:calendar:dtstart" < '2006/03/28 00:00:00' ORDER BY
> "urn:schemas:calendar:dtstart" ASC
>
> There are 2 appointments on 2006/03/27 but the query doesn't return one
> of them which is an all day event. What am I missing?
>
> TIA
>
date: Mon, 20 Mar 2006 15:49:49 +0100
author: Henning Krause [MVP]
Re: All day event not returned by query
Yes, I live in a GMT+2 timezone. I've fixed the query and now it works
OK.
Thanks a lot.
Henning Krause [MVP] wrote:
> Hello,
>
> one common issue here is the used timezone. Exchange stores all time
> settings in GMT. If you are living in a timezone of -5 hours, outlook will
> adjust the calendar fields with this. This will result in the time field
> having a value of '2006/03/26 19:00:00'.
>
> You must adjust your query accordingly.
>
> Greetings,
> Henning Krause [MVP]
>
>
> wrote in message
> news:1142840038.597665.103730@g10g2000cwb.googlegroups.com...
> > Hello,
> >
> > I'm using the following statement to query my calendar:
> >
> > SELECT "urn:schemas:httpmail:subject", "urn:schemas:calendar:location",
> > "urn:schemas:calendar:dtstart", "urn:schemas:calendar:dtend",
> > "urn:schemas:calendar:alldayevent", "urn:schemas:calendar:instancetype"
> > FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
> > "urn:schemas:calendar:dtstart" >= '2006/03/27 00:00:00' AND
> > "urn:schemas:calendar:dtstart" < '2006/03/28 00:00:00' ORDER BY
> > "urn:schemas:calendar:dtstart" ASC
> >
> > There are 2 appointments on 2006/03/27 but the query doesn't return one
> > of them which is an all day event. What am I missing?
> >
> > TIA
> >
date: 20 Mar 2006 23:12:32 -0800
author: unknown
|
|
