Hi, I'm a newbie, been using GTD for about 3 months and found it very helpful so thank you!
The problem is I have over 250 tasks at any one time, so I need to prioritise them. I do this by using the priority switch in outlook. Each week as part of my weekly review I mark as HIGH those tasks that I really need to do next week.
Now I need a view that will let me see, completed = no, AND (either, Due Date is in the next 7 days OR priority = High)
This will give me an easy stap shot of the top 20 or so tasks I've identified as got to get done this week.
Can any one help me with the SQL?
Rev. Charlie Ingram