Thanks Craig! That is what I was looking for.

The last end date was defaulting to getdate(), but I modified the second part of the isnull to be...