Skip to main content
Question

Report generation using date filter

  • August 5, 2024
  • 1 reply
  • 35 views

Forum|alt.badge.img+6

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

1 reply

Forum|alt.badge.img+10
  • Hero (Employee)
  • August 5, 2024

@aishwarya 

Hi,

 

If I understand correctly you need to have the popup of the date time field to only show a calendar. If the mask type is set as ‘DATEONLY’ in the report parameters it should only show the calendar. 

 

 

I hope this helps,

Regards,

 

Morris