I've got a fairly simple query. I'm attempting to pull some data based on a "FirstEffectiveDate" and a "CancelDate". What I'm doing is comparing the amount of time an insurance contract has been in-force. Unfortunately, if it is still in-force, the "CancelDate" field is blank/null. What I've...