Bug in Taskpad DASL?

[richardlandis]

I am running Outlook 2003 with the latest updates and I think I have
found a very simple bug in the Outlook tasks settings. Simplified as
much as possible the scenario is that I want to show only tasks that
have a due date of today.

1. In the Day/Week/Month view, I right click on the Taskpad and choose
"Customize Current View".
2. Push the Filter... button
3. Choose the Advanced tab
4. Choose the field "Due Date" and the Condition Today
5. Push Add to List
6. Push OK
7. Push OK
Your taskpad should now show today's tasks (thus far it works).

Now, for the bug:
1. Right click to again choose "Customize Current View"
2. Push the Filter.. button
3. This time choose the SQL tab, you should see some greyed out text.
4. Check the "Edit these criteria directly. All other tabls will be
unavailable." box.
5. Make no changes to the SQL!
6. Push OK
7. Push OK

Since this is the exact same SQL as before, you should have the same
results - but you may have noticed that the tasks due today have
disappeared!

Any idea of what is up?

Note: My real scenario is a more complex SQL query - but it is failing
on tasks due today and I believe it is related to the problem above.

Thanks in advance for any enlightenment!

 

[richardlandis]

Well, I found a workaround - but it is odd. Rather than using the
syntax that is generated by Advanced tabs, namely:
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%

I changed this to:
"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040"
= 'today'

And this works!

However, it is precisely the opposite when testing the Date Completed
(rather than the Due Date above). For Date Completed only the %today
syntax works, the = 'today' syntax fails).

Very strange.

Hope this helps someone .

RB