Filter for View

  • Thread starter Thread starter tdolan
  • Start date Start date
T

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.
 
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

Diane Poremsky said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top