![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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 |
#3
|
|||
|
|||
![]()
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 |
#4
|
|||
|
|||
![]()
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 |
#5
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
View range | DENNIS BROWN | Outlook and VBA | 1 | August 1st 07 03:59 PM |
Can I print all Appointments in a date range? (Outlook 2003) | Graphogoddess | Outlook - Calandaring | 0 | April 8th 07 11:20 PM |
Limit Range of Recurrence | J. Shaeffer | Outlook - Calandaring | 0 | November 28th 06 10:04 PM |
Help emailing worksheet range via Redemption | [email protected] | Outlook and VBA | 1 | July 17th 06 07:36 PM |
Calendar Date Range | Yoav | Outlook - Calandaring | 0 | March 24th 06 12:33 PM |