Thread: SQL Task Filter
View Single Post
  #2  
Old March 9th 09, 07:55 PM posted to microsoft.public.outlook.program_forms
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default SQL Task Filter



Try this:

(%next7days("urn:schemas:httpmail:reply-by")% OR
"urn:schemas-microsoft-comfficeffice#Keywords" = 'Agendas' OR
"urn:schemas-microsoft-comfficeffice#Keywords" = 'Projects')

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 6 Mar 2009 11:11:01 -0800 schrieb pdberger:

Good morning --

Using Outlook 2003 on a corporate server, I organize all my tasks into
categories with start and finish dates, except for those in two

categories:
Agendas & Projects. I'd like to filter for the following:

* Tasks in any category with a due date within 7 days
- plus -
* All tasks in the Agendas & Projects regardless of due date

I haven't been able to figure this out without an SQL query. Can someone
help me with this?

TIA

Ads