Getting range of appointments

[DENNIS BROWN]

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?

 

[Dmitry Streblechenko]

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?

 

[DENNIS BROWN]

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
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?

 

[Dmitry Streblechenko]

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
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?

 

[DENNIS BROWN]

Thanks!

--

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
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
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?