Hi,

In report screen want to get data according to date.so in report admin in dataset i have added the query and added parameter. Still not getting data.  In report screen how to add calendar filter without time. 

below i have added my query and attachment for reference

select 

e.user_def12 as bus,

e.user_def5 as busno,
convert(varchar,e.created_dttm,103) as CreatedDate
From
Escalation e
where 
and convert(varchar,e.created_dttm,103) ##Createddate $$Createddate

Is there any mistake in my query??

Please suggest.

Thanks in advance