View Single Post
  #5  
Old August 28th 07, 09:07 PM posted to microsoft.public.outlook.program_vba
DENNIS BROWN
external usenet poster
 
Posts: 51
Default Getting range of appointments

Thanks!

--

Thanks,
Dennis
"Dmitry Streblechenko" wrote in message ...
No, the first one won't work - how can an appointment start before August 1 and at the same time start after August 31?
It should be

[Start] = '8/31/2007 23:59' AND [End] = '8/1/2007 00:00'

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"DENNIS BROWN" wrote in message . ..
My complete line is
[Start] = '8/1/2007 23:59' AND [Start] = '8/31/2007 00:00'

Should it find it? It gets the entire day's appointments when I use
[Start] = '8/1/2007 23:59' AND [Start] = '8/1/2007 00:00'


--

Thanks,
Dennis
"Dmitry Streblechenko" wrote in message ...
Your value of sStartRange is greater than yhe value of sEndRange.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"DENNIS BROWN" wrote in message . ..
I'm using the FindNext(sFilter) to get the appointments within a day, and it works with the date syntax of
sStartRange date of '8/28/2007 23:59'
and sEndRange date of '8/28/2007 00:00', but it returns nothing if I extend it past a single day, such as
'8/1/2007 23:59' and '8/31/2007 00:00'.
Am I doing something wrong with the date syntax when extending past a single day range?

--

Thanks,
Dennis
Ads