In Outlook 2003 in Calendar view with Taskpad enabled, when I select a day in the Calendar other than "Today", then the Taskpad either:
1. is unchanged (shows the same tasks as when "Today" is selected, irrespective of which day is highlighted in the Calendar)
2. shows tasks active on the selected date, as well as all tasks with a due date in the future (when "Active Tasks for Selected Days" is enabled as the Taskpad View).
What I want, is a simple filter that will show only those tasks due on the date (other than "Today") selected in the Calendar, without the clutter and distraction of future tasks.
I am already aware of the clumsy solution that requires each task to be entered with both a "Start Date" as well as a "Due Date". But this creates other limitations, and considering that I have literally hundreds of tasks that I organize on a daily basis, it is simply not a practical solution.
Right-clicking the top row of the Taskpad, then selecting Customize Current View > Filter > Advanced, I can use the drop-down "Field" menu and choose "Due Date", then for the Condition choose "On". But I don't know what Value will get me the equivalent of the date selected in the Calendar.
If someone can tell me what the appropriate Value name is, that will solve this problem very elegantly.
Alternatively, if someone knows the appropriate SQL code to type in on the SQL tab (Customize Current View > Filter > SQL), then that will similarly solve the problem.
(Judging by the various groups and forums, many Outlook users are looking for this solution. It's such an obvious feature that it's hard to believe Outlook still doesn't have it built-in out-of-the-box even after all these years.)