View Single Post
  #1  
Old September 17th 07, 08:27 PM posted to microsoft.public.outlook
[email protected]
external usenet poster
 
Posts: 2
Default Advanced Search Criteria - Dynamic Date Range

I am attempting to create a Search Folder that will show all e-mails
received over 45 days ago. I am having a devil of a time trying to
figure out how to specify this in the Advanced Search Criteria. If I
put the field 'Sent' with condition 'on or before' and the value of
'8/3/2007' it returns the correct list of messages. Since 8/3/2007
will only be valid on the date 9/17/2007 I was trying to put
something in the value field that would be dynamic. I have tried
'now-45', 'today-45','dateadd("d",-45,now', and
'dateadd("d",-45,today)' . None of these return the correct set of
messages. I have searched the web and I get some reasonably simple
examples but nothing relating to dynamic dates.

Any ideas? Can this even be done?

Thanks for any insight that can be provided.

Mike

Ads