Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   SQL Task Filter (http://www.outlookbanter.com/outlook-using-forms/87342-sql-task-filter.html)

pdberger March 6th 09 08:11 PM

SQL Task Filter
 
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

Michael Bauer [MVP - Outlook] March 9th 09 07:55 PM

SQL Task Filter
 


Try this:

(%next7days("urn:schemas:httpmail:reply-by")% OR
"urn:schemas-microsoft-com:office:office#Keywords" = 'Agendas' OR
"urn:schemas-microsoft-com:office:office#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



All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com