![]() |
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 |
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