today - 45 seems to work on the modified date. (I moved to a new server less
than 45 days ago and had to use today - 5 - but noticed it found older items
that I moved within the last 5 days, but not every thing I imported.)

45 days ago seems to work correctly.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



wrote in message
ups.com...
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