Date range selection problem

[#1]

I've created a date Input selection box.

I selected Call Activity From >= 12/01/2014 and Call Activity To <= 12/06/2014.

It only shows records from 12/01/2014 - 12/05/2014. I do have records for 12/06/2014 that didn't show up in the report. It show record one day less than the last date selected.

How to resolve this? Thanks!!

I had set the Variable Event triggers Action as below for the expression:

For Call Activity From

='>=' & CallActivitiesFrom & '<=' & CallActivitiesTo

For Call Activity FromTo

='>=' & CallActivitiesFrom& '<=' & CallActivitiesTo

[Josh_Good]

Hi Suzanne,

I would recommend you check that your dates are not actually date-times.  If they are then all of your data connected to 12/06/2014 would be great than the parameters you indicated.  You can check this by extending you range to 12/07/2014 and see if the data from the 6th appears.  You could also check this by putting the dates into a listbox and changing the formatting to datetime.

-Josh

Qlik

[#3]

it doesn't seems to work.

[Josh_Good]

I've attached the file again and check that it is working on my end.  Let me know if it doesn't work for you.

-Josh

Qlik