ERROR: Database error.
Cannot execute the query: SELECT count(*) as num FROM exhbt_main
where enddate >= '2014-04-01' and exdate <='2014-04-31'
order by exhbt_main.exdate
MySql Error returned: Incorrect DATE value: '2014-04-31'
MySql Error code: 1525