Hi,

My sql is:
select 'SYEN' as hospital, count(PHONE_NO) as countnumber from smsrequestqueue
where success_ind = 'Y'
and sms_type is null
and entitymstr_id = 1
and sendtime is not null
and content like 'Thank%'
and created_datetime >= trunc(to_date({CommonValue_date1},'yyyy-mm-dd hh24:mi:ss'), 'd')+1
and created_datetime < trunc(to_date({CommonValue_data1},'yyyy-mm-dd hh24:mi:ss'), 'd')+8
group by entitymstr_id;

The output is:
https://drive.google.com...mJMA9sQ/view?usp=sharing

[img=https://drive.google.com/file/d/1gYUYB-UfmcIlWIli3I-Y3lH8VmJMA9sQ/view?usp=sharing]a1[/img]

I assume the input box will be single one. But there are 2 boxes. The second is not required. How can I change to single one?

Thanks,

John

Sorry. It's just a typo. I do have only one CommonValue. And set it to type date & time. But there are 2 input boxes for picking up date, just like the picture shows.

This is correct as you can enter several values for a restriction (up to 4)...
If you want only one value, set the restriction property 'Prompt restriction' to 'Prompt only one value'