Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Outlook / Programming VBA / August 2007

Tip: Looking for answers? Try searching our database.

Getting range of appointments

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DENNIS BROWN - 28 Aug 2007 14:29 GMT
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?

Signature

Thanks,
Dennis

Reply to this Message
Dmitry Streblechenko - 28 Aug 2007 18:12 GMT
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
 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
Reply to this Message
DENNIS BROWN - 28 Aug 2007 18:29 GMT
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'

Signature

Thanks,
Dennis

 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" <DennisTBrown@Comcast.net> wrote in message news:Ro2dnV_sxf7cvknbnZ2dnUVZ_t6onZ2d@comcast.com...
   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
Reply to this Message
Dmitry Streblechenko - 28 Aug 2007 19:45 GMT
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
 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" <dmitry@dimastr.com> wrote in message news:OnFYCaZ6HHA.3528@TK2MSFTNGP04.phx.gbl...
   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" <DennisTBrown@Comcast.net> wrote in message news:Ro2dnV_sxf7cvknbnZ2dnUVZ_t6onZ2d@comcast.com...
     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
Reply to this Message
DENNIS BROWN - 28 Aug 2007 20:07 GMT
Thanks!

Signature

Thanks,
Dennis

 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" <DennisTBrown@Comcast.net> wrote in message news:iYmdnUpS_b3pxknbnZ2dnUVZ_qainZ2d@comcast.com...
   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" <dmitry@dimastr.com> wrote in message news:OnFYCaZ6HHA.3528@TK2MSFTNGP04.phx.gbl...
     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" <DennisTBrown@Comcast.net> wrote in message news:Ro2dnV_sxf7cvknbnZ2dnUVZ_t6onZ2d@comcast.com...
       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
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.