i found a much simpler alternative to the problem using the following query then binding the data to the listview
see query below
Select * from SiteInformation
where SiteStateID = 1 and StatusOfLease = 'Active' and DateAdd(Month, -6,RentalExpirationDate) = CONVERT(VARCHAR(10),GETDATE(),111)