M
Montana DOJ Help Desk
Outlook 2000
I'm trying to create the following 3 views:
1) Past events - Events where the end date < today
2) Current events - Events where the start date <= today, and the end
date >= today
3) Future events - Events where the start date > today
If possible, I would like to make each of these 3 views work for one-time
events, and for recurring events (some occurrences may be in the past, but I
only want to see the occurrences that are in the future). In addition, I'd
like to limit each view to a time frame of 3 months. Using the future
events view as an example, the view should show me events that are upcoming
within the next 3 months, but not the events that are more than 3 months
away.
I know that I need some calculated fields in order to pull this off, and
I've worked with simple calculated fields. But in order to do everything
that I want to do here, the formulas will have to be more complex than what
I've previously dealt with in Outlook. I've been trying to research
calculated fields in the Outlook Help, but haven't found much that is
helpful.
Can someone show me what a formula of the kind that I need would look like?
-- Tom
State of Montana
Department of Justice Help Desk
"Making the world a safer place."
I'm trying to create the following 3 views:
1) Past events - Events where the end date < today
2) Current events - Events where the start date <= today, and the end
date >= today
3) Future events - Events where the start date > today
If possible, I would like to make each of these 3 views work for one-time
events, and for recurring events (some occurrences may be in the past, but I
only want to see the occurrences that are in the future). In addition, I'd
like to limit each view to a time frame of 3 months. Using the future
events view as an example, the view should show me events that are upcoming
within the next 3 months, but not the events that are more than 3 months
away.
I know that I need some calculated fields in order to pull this off, and
I've worked with simple calculated fields. But in order to do everything
that I want to do here, the formulas will have to be more complex than what
I've previously dealt with in Outlook. I've been trying to research
calculated fields in the Outlook Help, but haven't found much that is
helpful.
Can someone show me what a formula of the kind that I need would look like?
-- Tom
State of Montana
Department of Justice Help Desk
"Making the world a safer place."