Filtering based on Reminder Time column doesn't work properly

I was trying to define a view for Todo Bar showing only tasks with passed
reminder time. My filter definition was:
Complete equals no
Reminder Time on or before Now

Surprisingly the view shows tasks with reminder time set within 24 hours
from now as well. I went to SQL tab of Filter panel and 'Now' is resolved
properly:
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b"
= 0 AND
"http://schemas.microsoft.com/mapi/id/{00062008-0000-0000-C000-000000000046}/85020040"
= '2010-01-02 17:42')

Since user-defined columns cannot be used for filtering views, I'm stuck...
any help will be appreciated.
I'm using Outlook 2007 SP2.

I believe it filters as of the end of the day, as that is when tasks are
officially due, not at the time the reminder fires.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


"strach" wrote in message
...
I was trying to define a view for Todo Bar showing only tasks with passed
reminder time. My filter definition was:
Complete equals no
Reminder Time on or before Now

Surprisingly the view shows tasks with reminder time set within 24 hours
from now as well. I went to SQL tab of Filter panel and 'Now' is resolved
properly:
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b"
= 0 AND
"http://schemas.microsoft.com/mapi/id/{00062008-0000-0000-C000-000000000046}/85020040"
= '2010-01-02 17:42')

Since user-defined columns cannot be used for filtering views, I'm
stuck... any help will be appreciated.
I'm using Outlook 2007 SP2.

"Diane Poremsky [MVP]" wrote in message
...
I believe it filters as of the end of the day, as that is when tasks are
officially due, not at the time the reminder fires.

Thanks for the answer Diane, however it does not work that way. I've checked
it by defining a series of 25 future tasks with reminders varying by one
hour. It is 7:42 pm now and the latest task shown is the one with reminder
set to tomorrow, 7 pm.

.... and yes, I've checked if my Windows date is correct

I'll see if I can find my notes on it and try to repro your scenario -
someone a few months ago asked about it and all I can remember is there is
an inconsistency between what it does and what is expected. The expectation
was that it would find all tasks due before "now" - but tasks only know full
days, not hours. It's possible that because its past your "working hours"
that it rolls to tomorrow.

I also know Outlook 2007 SP2 changed behavior - tasks fire at the appointed
time but the are not 'due now' - they are due at the end of the working day.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


"strach" wrote in message
...
"Diane Poremsky [MVP]" wrote in message
...
I believe it filters as of the end of the day, as that is when tasks are
officially due, not at the time the reminder fires.

Thanks for the answer Diane, however it does not work that way. I've
checked it by defining a series of 25 future tasks with reminders varying
by one hour. It is 7:42 pm now and the latest task shown is the one with
reminder set to tomorrow, 7 pm.

... and yes, I've checked if my Windows date is correct

"Diane Poremsky [MVP]" wrote in message
...
The
expectation was that it would find all tasks due before "now" - but
tasks only know full days, not hours.

That would be strange since ReminderTime field has a specific value that
should be used for comparison as-is, including time part not only the date.
'Due' characteristic of the task (which inherently can be understood as the
end of the day) should not be involved here at all. This seems to be
confirmed by the fact that tomorrow's tasks meet the filtering criteria not
from the whole tomorrow, but only from the range [Now() + 24 hours].


It's possible that because its
past your "working hours" that it rolls to tomorrow.

Following this idea I changed working hours to include Saturday and Sunday,
00:00 till 23:59, it didn't help though.

I also know Outlook 2007 SP2 changed behavior - tasks fire at the
appointed time but the are not 'due now' - they are due at the end of
the working day.

Again, I think involving 'due' characteristics into reminder field is a
wrong way.