Outlook 2003: SQL DASL Query not quite right...

[Aaron]

I've been fidling with a DASL query to set my task filter just right. If
there is a simpler solution (or any solution!) I would appreciate a nudge in
the right direction.

Desired pseudocode filter for Outlook tasks:

All tasks that are not completed
AND
(
Tasks with Start Date less than or equal to now
OR
Tasks that do not have Start Date set
)

This keeps tasks that I don't even want to start yet from cluttering my
current todo list.
So I have come up with:


"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003" <> 2

AND

(

"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040"
<=
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040")%

OR


"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040" IS NULL
)

But this code gives a parse error. Is there a DASL function for current
system date/time (like Now()) that would let me complete the logic for "start
date less than or equal to now()"

The function I found for deriving Today is the long URN
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040")%

I tried to watch what code would be generated from terms like "last seven
days", but there seems to be a funky %function for each of those special
cases.

This either makes complete sense or no sense at all, so if anyone
understands what I'm saying I'd appreciate any guidance here.

Aaron