|
| 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. |
|
|||||||
| Tags: appointments, getting, range |
|
|
Thread Tools | Display Modes |
|
#1
August 28th 07, 03:29 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Getting range of appointments
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
August 28th 07, 07:12 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting range of appointments
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
August 28th 07, 07:29 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting range of appointments
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
August 28th 07, 08:45 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting range of appointments
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
August 28th 07, 09:07 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | Timothy.Rybak@gmail.com | Outlook and VBA | 1 | July 17th 06 07:36 PM |
| Calendar Date Range | Yoav | Outlook - Calandaring | 0 | March 24th 06 12:33 PM |
Linear Mode
