you are missing quotes in datetime string.
select count(ID) as count from Customerloandata with (nolock) where createdby = 4 AND isnull(QCPROCESSED,0) = 0 AND isnull(QCTOVERIFY,0) = 1 and isnull(deleted,0) = 0 AND createdon >='2014-01-01 00:00:00' and createdon<='2014-04-01 00:00:00'