To make sure any answer is correct, please read the link under the signature line on how to post questions.

Can't you just do the following to pick up the null dates:

where ((coitem_log.activity_date between '7/1/2013 00:00:00:000' and '7/31/2013 23:59:59:999') or coitem_log.activity_date is null)