Problem solved!  Thank You

Thanks to both of you.  The case statement is the best choice for me.  It turns out a null date is not appropriate in this situation and I am using the...

Thanks for the suggestions.  View this one http://www.sqldts.com/default.aspx?225 to see what ending up working for me.