What SQL functions can I use to create Outlook mail view filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a view on a message folder with a filter to show all the
messages from this quarter. I hoped to use .....

datepart("qq",""urn:schemas:httpmail:date") = datepart("qq",now())

..... which I believe to be correct SQL. However, I get "Error parsing your
SQL text when I try to save the filter.

Where did I go wrong? Am I naive or dyslexic?
 
You can't use any standard functions at all. You can use only those "verbs" that the DASL syntax supports, e.g.:

%lastweek("urn:schemas:httpmail:date")%

AFAIK, the only such supported verbs are that you can see in the Outlook filter UI

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top