How to create the customized Outlook SQL DASL for selected days?

  • Thread starter Thread starter Bill Lin
  • Start date Start date
B

Bill Lin

Outlook 2007/2010 provided pre-defined view for tasks due by the selected
days. It seems the SQL DASL Filter dialog has the ability to do it, but I
don't know what's the property tag for selected days
I am using the filter below to get tasks due on today
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%
When I changed the selected days on the calendar taskpad view, it won't get
the tasks due on the date I selected. Can't find any documents to use SQL
DASL filters except for Andre Delin's weblog: Doing more with Outlook filter
and SQL DASL syntax

Can you please help? Thanks

Bill
 
The help on PropertyAccessor has a lot more about using DASL filters, but
doesn't cover everything. Usually to construct a DASL filter many of us go
to the customize dialog for views and in the filter section we create the
filter in the Advanced tab and then look at the SQL tab to get the
equivalent DASL terms.

The filter you refer to in your message is looking at the task DueDate
property for dates of today.

The SQL tab will show the DASL MAPI property tag for a property added in the
Advanced tab.

I also use a MAPI viewer to get DASL tags for any property, I use OutlookSpy
as my MAPI viewer (www.dimastr.com).
 
Back
Top