| Author |
Message |
Brett Smith
Guest
|
 Posted:
Fri Aug 19, 2005 12:05 am Post subject:
WEBDav Select for Multi Day Appointments |
|
|
I need some help on getting appoingment items.
Currently I am querying for items in a date range (dtstart >=
myStartDate and dtend <= myEndDate and instancetype <>1) The problem I am
having is when an appointment starts on one day and ends on another. if
either the start or the end does not fall within my date range I do not get
the appointment.
The other issue is that with this type of appointment. only one items
gets generated (as apposed to reoccuring appointemnts which get returned for
every occurance.) I can work around this by evaluating the start and end
dates, and generating events in my own program to populate the days that
fall within the date range. It would, however, be easier if there was a way
to have exchange do this for me :).
|
|
| Back to top |
|
 |
Michael
Guest
|
| Posted:
Fri Aug 19, 2005 12:59 am Post subject:
Re: WEBDav Select for Multi Day Appointments |
|
|
May be I did not understand your question but solution seems to be simple.
You said that problem is if appointment starts on one day and ends on next
day. Why you do not simple set myEndDate as end of next day?
Also you can use logical operators OR and AND and also use brackets "(" ,
")" to create better condition.
Michael
-------------------------------
If you need WebDAV API for Exchange server,
use our component WebDAV .NET for Exchange.
Check out http://www.independentsoft.com
"Brett Smith" <bsmith at comppro dot com> wrote in message
news:#6Os8dCpFHA.3364@tk2msftngp13.phx.gbl...
| Quote: | I need some help on getting appoingment items.
Currently I am querying for items in a date range (dtstart >=
myStartDate and dtend <= myEndDate and instancetype <>1) The problem I am
having is when an appointment starts on one day and ends on another. if
either the start or the end does not fall within my date range I do not
get
the appointment.
The other issue is that with this type of appointment. only one items
gets generated (as apposed to reoccuring appointemnts which get returned
for
every occurance.) I can work around this by evaluating the start and end
dates, and generating events in my own program to populate the days that
fall within the date range. It would, however, be easier if there was a
way
to have exchange do this for me :).
|
|
|
| Back to top |
|
|
Brett Smith
Guest
|
| Posted:
Tue Aug 23, 2005 12:59 am Post subject:
Re: WEBDav Select for Multi Day Appointments |
|
|
I found the solution. It was just a matter of logic
for a single day: dtestart <= myDate AND dteend >= myDate (I was using:
dtestart = myDate)
for a range of dates: dtestart <= myEndDate AND dteend >= myStartDate (I was
using: dtestart >= myStartDate AND dteend <= myEndDate)
I was thinking to narrowly, and exchange was giving me exactly what I asked
for. Rather than asking for appointments that occur in a date range I was
asking for appointments that ONLY occur ENTIRELY within the date range!
/* Start of Rant.
Thank you for replying. It discourageing to Google a problem in
newsgroups and find several other people asking the same question, and no
one giving any suggestions. That is also why I am replying with my solution.
I would like other people to bennifite from this discussion. There is
nothing worse that reading through an entire thread discussing the same
problem your having, and never finding out shat the solution was. People
need to keep in mind that these groups are for the public, not just your own
personal referance.
End of Rant.*/
"Michael" <michael@discussions.microsoft.com> wrote in message
news:OxgrrnEpFHA.496@TK2MSFTNGP10.phx.gbl...
| Quote: | May be I did not understand your question but solution seems to be simple.
You said that problem is if appointment starts on one day and ends on next
day. Why you do not simple set myEndDate as end of next day?
Also you can use logical operators OR and AND and also use brackets "(" ,
")" to create better condition.
Michael
-------------------------------
If you need WebDAV API for Exchange server,
use our component WebDAV .NET for Exchange.
Check out http://www.independentsoft.com
"Brett Smith" <bsmith at comppro dot com> wrote in message
news:#6Os8dCpFHA.3364@tk2msftngp13.phx.gbl...
I need some help on getting appoingment items.
Currently I am querying for items in a date range (dtstart >=
myStartDate and dtend <= myEndDate and instancetype <>1) The problem I am
having is when an appointment starts on one day and ends on another. if
either the start or the end does not fall within my date range I do not
get
the appointment.
The other issue is that with this type of appointment. only one items
gets generated (as apposed to reoccuring appointemnts which get returned
for
every occurance.) I can work around this by evaluating the start and end
dates, and generating events in my own program to populate the days that
fall within the date range. It would, however, be easier if there was a
way
to have exchange do this for me :).
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in