View Single Post
  #2  
Old July 11th 08, 03:42 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default View filter on mail items sent in the last 30 days

As you've already determined, you can't. The DASL syntax for view filters
doesn't support expression like today() - 30. The best you can do is filter
for items after a specific date and change that literal date value in the
filter every day.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"David" wrote:

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?

Ads