On Thu, 17 Jan 2019, David G. Johnston wrote:
Why is next_contact allowed to be null?
David, There are a number of reasons. The prospect might have retired, told me to pound sand, or has put off a decision.
Your concept of "most current row" is strictly based upon next_contact so if next_contact is null it is impossible to know whether it is the most current row (consider that two activities could be missing the next_contact date - which of those is the most current?)
That's quite true. I realize I've been asking the question incorrectly. What I want is a list of contacts to make today. This includes ones that should have been made earlier but weren't and excludes earlier contacts that have no scheduled next contact (therefore, the nulls.). Does this clarify what I'm asking of the data? Thanks, Rich
