MS Office Forum / Outlook / Calendaring / January 2006
Taskpad in Calendar View
|
|
Thread rating:  |
Sarah - 10 Jan 2006 19:01 GMT 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 - 11 Jan 2006 10:44 GMT 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,
Sarah - 11 Jan 2006 18:35 GMT 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? [quoted text clipped - 51 lines] > > > > Thanks, Sarah - 11 Jan 2006 18:47 GMT 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? [quoted text clipped - 51 lines] > > > > Thanks, Judy Gleeson MVP Outlook - 12 Jan 2006 08:24 GMT 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. > > "Judy Gleeson MVP Outlook" wrote: > >> 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" <Sarah@discussions.microsoft.com> wrote in message >> news:77446438-06A4-4026-A9F6-07FA47AF04A3@microsoft.com... >> > 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, >> >> >>
|
|
|