public void Given_with_deleted_and_status_date_when_execute_then_result_returns_correct_count()
        {
            //given
            var expectedDate = new DateTime(2014, 01, 01);

            var checklists = new List<Checklist>
                                 {
                                     new Checklist{Status = Checklist.STATUS_DRAFT, ChecklistCreatedOn = DateTime.Now, LastModifiedOn = expectedDate, Deleted = false},
                                     new Checklist{Status = Checklist.STATUS_DRAFT, ChecklistCreatedOn = DateTime.Now, LastModifiedOn = DateTime.Now, Deleted = true},
                                     new Checklist{Status = Checklist.STATUS_DRAFT, ChecklistCreatedOn = DateTime.Now, LastModifiedOn = expectedDate, Deleted = true},
                                     new Checklist{Status = Checklist.STATUS_COMPLETED, ChecklistCompletedOn = DateTime.Now},
                                     new Checklist{Status = Checklist.STATUS_ASSIGNED, QaAdvisorAssignedOn = DateTime.Now},
                                     new Checklist{Status = Checklist.STATUS_SUBMITTED, ChecklistSubmittedOn = DateTime.Now}
                                 };

            _queryableWrapper.Setup(x => x.Queryable())
                .Returns(checklists.AsQueryable);

            //when
            var target = new GetChecklistsQuery(_queryableWrapper.Object);
            var result = target
                .WithDeletedOnly()
                .WithStatusDateBetween(expectedDate, expectedDate.AddDays(1))
                .Execute();
            //then

            Assert.That(result.Count, Is.EqualTo(1));
        }