存储过程返回false值

I wrote a stored procedure for getting the count from a column but when I execute the procedure its returning a date value. While separate query execution returns the required result set.I wrote a stored procedure for getting the coun