Filter for View

[tdolan]

I'm trying to create a filter for a view to only show the last 14 days of
appointments. I get it to work if I choose start, between and manually type
the dates. But I want it to you the system date and calculate backwards to
when 14 days would be.

 

[Diane Poremsky [MVP]]

try 'between today and 14 days ago'

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[tdolan]

Thanks Diane. That worked. I was making it more complicated. I never would
have that the verbage would work. I was trying to use a formula along the
lines of "today() - 14".

Tami

try 'between today and 14 days ago'

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

I'm trying to create a filter for a view to only show the last 14 days of
appointments. I get it to work if I choose start, between and manually
type
the dates. But I want it to you the system date and calculate backwards
to
when 14 days would be.