Outlook Appointment Item exceeds beyond the date range

Status
Not open for further replies.
M

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
confused.png
. How to avoid it.

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

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.
< Outlook Rules Case Sensitive | Outlook 2007 vs Outlook 2010 on Windows 8 >
Similar threads
Thread starter Title Forum Replies Date
N Adding Appointment Item in Outlook to Shared Calendar Folder Outlook VBA and Custom Forms 7
M Outlook Appointment item does not show the item outside the date range Using Outlook 2
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
S New Outlook Appointment - Select All Body Text and Change Font and Size Outlook VBA and Custom Forms 1
W Space in an Outlook appointment body Using Outlook 0
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
Diane Poremsky Create an Outlook appointment from an email message Using Outlook 4
J Outlook calendar...How to add an event or appointment without a border around it? Using Outlook 9
F Outlook 2010 Search Appointment Notes Using Outlook 0
Tech Checkers Make Outlook add Contact Card Address in Location Field based on Appointment Subject Name. Using Outlook 2
K Importing appointment body from excel in outlook 2010 Using Outlook 1
M Outlook appointment in asp.classic Using Outlook 2
L Showing @live account in outlook 2013 calendar as private appointment Using Outlook 1
A iCloud add-on for Outlook: Reminder for new appointment is set to 'None' by default. How to change? Using Outlook 6
J Outlook 2010: can't forward appointment on custom form Using Outlook 1
Rijotech Outlook 2013 Appointment list custom positions? Using Outlook 2
R How to copy outlook 2010 shared calendar appointment or meeting to personal calendar by vba? Outlook VBA and Custom Forms 1
R Static Resources in Custom Outlook Appointment Form Using Outlook 2
L Outlook 2007 Code for Note Fields of Appointment Using Outlook 102
S Calendar deletes appointment after entry from both Outlook and Icloud calander Using Outlook 1
H Reocurring outlook appointment (office 2010) does not update Outlook.com Using Outlook 3
C Outlook Appointment issue when synchronized with iCloud 2 Using Outlook 8
M "New Appointment from Contact" command missing from Outlook 2003 Using Outlook 1
B Outlook Calendar Appointment Problem Using Outlook 1
O Rescheduling appointment on Outlook 2010 for Windows creates duplicate entry Using Outlook 2
T Outlook makes every appointment recurring and set to the current date/time Using Outlook 2
P Create appointment to custom (shared) outlook calendar Outlook VBA and Custom Forms 3
J Outlook Appointment recurrence setting Outlook VBA and Custom Forms 4
S Custom Form overwriting the default appointment form in outlook 20 Outlook VBA and Custom Forms 1
Q How outlook Store Appointment Outlook VBA and Custom Forms 1
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 2
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 1
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
e_a_g_l_e_p_i I can't believe what I am seeing when trying to install Outlook 2021 Using Outlook 9
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3

Similar threads

Top