Outlook Appointment Item exceeds beyond the date range

Status
Not open for further replies.

montu

Member
Outlook version
Outlook 2010 64 bit
Email Account
IMAP
Hello!

I want to retrieve the appointment items between my date range. For that purpose I am using following logic:-

"[Start]<='" & EndDate & " 11:59 pm' And [End]>='" & StartDate & " 12:00 am'"

where StartDate and EndDate is my Date Range in dd/MM/yyyy format.

In one condition I am giving the StartDate=08-06-2012 and EndDate=10-06-2012. My code is giving me all the records between this date range but one of an appointment item occurs on 11-06-2012(and its a all day event and exceeds my date range) still I am getting this item in my list
. How to avoid it.

I tried to remove the "=" from above logic still didn't get any success. Help Me!
 

montu

Member
Outlook version
Outlook 2010 64 bit
Email Account
IMAP
Thanks Diane for your reply!

No Its not a recurring item nor multi-day event. Its shows me its start time as 00:00 and end time as 00:00. Its may be the reason. How to overcome this problem?
 
Status
Not open for further replies.
Top