Taskpad in Calendar View

[Sarah]

I'm seeing many posts regarding displaying active tasks in calendar view. My
taskpad was working perfectly up until just recently. I had been displaying
tasks that were due that day, a check box that allowed me to check off tasks
as I completed them and, for that sense of accomplishment, had the taskpad
sort the completed tasks down to the bottom of the list (they appeared greyed
out, with a line through them).

All of a sudden, all of my active tasks appeared on the taskpad. I tinkered
with it and by entering the formula below in the filter, I was able to get it
back to my former view:

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%)
OR
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%)

This morning, the taskpad is only showing tasks with a start and due date of
today, leaving off active tasks with prior start dates -- despite the fact
that I have changed nothing. What is going on with Outlook? I know it's buggy
(for example, why does it flip out when you try to start a task in one month
and set a due date in the next), but, as someone who relies on my taskpad, I
am severely hampered by these problems. Does anyone have a suggestion?

Thanks,

 

[Judy Gleeson MVP Outlook]

This one's probably right up my alley. So exactly what is your current
problem you want help with?

Could you please state your version.

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

 

[Sarah]

Judy, thanks for responding. I'm using Outlook 2003.

The issue is that I want my taskpad to show uncompleted items with a due
date on or before today, regardless of start date, as well as tasks completed
today. Yesterday, it was only showing tasks with a start date of today. As I
mentioned, it did this until recently (unfortunately, I did not document the
settings as I did not anticipate this sudden betrayal).

I tried changing the formula to:
(%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040")%)
OR(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%))
OR(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%))

1st clause: start date = today
2nd clause: due date = last seven days, status = not started
3rd clause: status = completed, date completed = today

This almost works but it includes, for some reason, tasks with start dates
of today and the next day. If I remove the start date formula, the tasks with
a start date of today go away.

So, I went through all tasks and changed the start date to yesterday's date.
I then set the filter on the tasks pad to status "doesn't matter" and on the
advanced tab to start date = today. It finally displayed what I wanted it to
display.

That about sums it up. Thanks!

This one's probably right up my alley. So exactly what is your current
problem you want help with?

Could you please state your version.

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

I'm seeing many posts regarding displaying active tasks in calendar view. My
taskpad was working perfectly up until just recently. I had been displaying
tasks that were due that day, a check box that allowed me to check off tasks
as I completed them and, for that sense of accomplishment, had the taskpad
sort the completed tasks down to the bottom of the list (they appeared greyed
out, with a line through them).

All of a sudden, all of my active tasks appeared on the taskpad. I tinkered
with it and by entering the formula below in the filter, I was able to get it
back to my former view:

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%)
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%)

This morning, the taskpad is only showing tasks with a start and due date of
today, leaving off active tasks with prior start dates -- despite the fact
that I have changed nothing. What is going on with Outlook? I know it's buggy
(for example, why does it flip out when you try to start a task in one month
and set a due date in the next), but, as someone who relies on my taskpad, I
am severely hampered by these problems. Does anyone have a suggestion?

Thanks,

 

[Sarah]

Okay, Judy, I did some more tinkering and I think I've got it now. If I move
the start date clause to the end of the SQL formula, it works:

(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%))
OR(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%))
OR(%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040")%)

I don't know if anyone else is interested in this particular taskpad view
but if you are, right click on the taskpad, click customize view, click
filter, go to the SQL tab and check the box at the bottom and then paste the
above criteria in the box, click OK, OK, and then cross your fingers.

This one's probably right up my alley. So exactly what is your current
problem you want help with?

Could you please state your version.

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

I'm seeing many posts regarding displaying active tasks in calendar view. My
taskpad was working perfectly up until just recently. I had been displaying
tasks that were due that day, a check box that allowed me to check off tasks
as I completed them and, for that sense of accomplishment, had the taskpad
sort the completed tasks down to the bottom of the list (they appeared greyed
out, with a line through them).

All of a sudden, all of my active tasks appeared on the taskpad. I tinkered
with it and by entering the formula below in the filter, I was able to get it
back to my former view:

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%)
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%)

This morning, the taskpad is only showing tasks with a start and due date of
today, leaving off active tasks with prior start dates -- despite the fact
that I have changed nothing. What is going on with Outlook? I know it's buggy
(for example, why does it flip out when you try to start a task in one month
and set a due date in the next), but, as someone who relies on my taskpad, I
am severely hampered by these problems. Does anyone have a suggestion?

Thanks,

 

[Judy Gleeson MVP Outlook]

well done!
--

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

Okay, Judy, I did some more tinkering and I think I've got it now. If I move
the start date clause to the end of the SQL formula, it works:

(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 0 AND
%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%))OR(("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"
= 2 AND
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%))OR(%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81040040")%)

I don't know if anyone else is interested in this particular taskpad view
but if you are, right click on the taskpad, click customize view, click
filter, go to the SQL tab and check the box at the bottom and then paste the
above criteria in the box, click OK, OK, and then cross your fingers.

This one's probably right up my alley. So exactly what is your current
problem you want help with?

Could you please state your version.

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

I'm seeing many posts regarding displaying active tasks in calendar view. My
taskpad was working perfectly up until just recently. I had been displaying
tasks that were due that day, a check box that allowed me to check

off
tasks

as I completed them and, for that sense of accomplishment, had the taskpad
sort the completed tasks down to the bottom of the list (they

appeared
greyed

out, with a line through them).

All of a sudden, all of my active tasks appeared on the taskpad. I tinkered
with it and by entering the formula below in the filter, I was able

to
get it

back to my former view:

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"

= 0 AND

%last7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%)

OR

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003"

= 2 AND

%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/810f0040")%)

This morning, the taskpad is only showing tasks with a start and

due
date of

today, leaving off active tasks with prior start dates -- despite

the
fact

that I have changed nothing. What is going on with Outlook? I know

it's
buggy

(for example, why does it flip out when you try to start a task in

one
month

and set a due date in the next), but, as someone who relies on my taskpad, I
am severely hampered by these problems. Does anyone have a suggestion?

Thanks,