David:
I, too, have spent significant time searching the web and experimenting to find an answer to this very question. All answers I found are vague, don't work, or simply say you can't do it. Happily, I stumbled onto a solution that is amazingly simple. I found it in a excerpt from the book "Sams Teach Yourself Microsoft Office Outlook 2003 in 24 Hours" by Diane Poremsky (Reference: See Figure 3.13
http://www.informit.com/store/produc...sbn=0672325543 ). I am using Outlook 2007 so I'm guessing it works for Outlook 2010 as well.
Here's what you do. The ***'ed step is the 'secret' step:
1. Create a Custom View
2. Edit that view and click the "Filter..." button
3. Click the "Advanced" tab
4. Click the "Field" drop-down button and select "Received"
5. Click the "Condition" drop-down and select "on or after"
***6. Click in the "Value" field and type "30 days ago" ('30' can be any integer)
7. Click "Add to List", "OK", "OK"
You will notice that this solution does not use SQL. I checked the SQL tab after following these steps and found that the correct date is magically hard coded into the expression. Thus, this still doesn't answer how to write a general SQL statement. However, it does the job.
Hope this helps!
P.S. This is my first post. Any feedback would be appreciated.
---
Quote:
Originally Posted by David
While trying to create what I thought was a simple view filter to show mail
items sent in the last 30 days I've learned that Outlook doesn't accomodate
this via simple configuration. I tried doing an Advanced filter but I'm
still constrained by the same limitations (e.g. last 7 days, last month...).
I'm no wiz with SQL but it seems this is the only place where I can
accomplish what I'm after. I tried the expression below but it didn't pass
the SQL parsing:
"urn:schemas:httpmail:date" = today() - 30
How can I apply a filter that will show me all email sent in the past 30 days?
|