I'm trying to create a custom view of overdue tasks that doesn't contain
tasks with No Due Date. Unfortunately, it doesn't seem possible to use
negative numbers as a "days from now" condition.
By definition "No due date" tasks should never considered overdue, so they
shouldn't show up on a custom view which has a criterion of "Is Overdue".
But, as you've discovered, they do. Bug.
The trick is in realizing that Entourage actually assigns a date of Jan.1,
1904 (earliest possible "integer" date on a Mac) to "No Due Date" tasks,
which is why they appear at the earliest part of chronological list, but
then get re-interpreted as same date in 2034 or so (after the latest
possible "integer" date) for custom view criteria. Impossible to figure out.
So this works:
Match <if ALL criteria are met>
Is Incomplete
Is Overdue
Due Date <Is less than> <0 > days from now
--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <
http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <
http://macscripter.net/scriptbuilders/>
Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.
PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
