how to display in b/w selected values?

[gkcchowdary]

my data like

date:

1/1/2014

2/2/2014

3/3/2014

4/4/2014

.

.

.

.

.

11/11/2014

12/12/2014

when i select any two dates i want display in between date data display.

ex: i selected 2/2/104 and 8/8/2014 dates .so i want display in b/w this two dates .how?

[Anonymous]

Hi, the following expression works =max(Date)-Min(Date) - it will find the maximum and minimum date in your date field and return the answer in days (it will work on your selected dates). Hope this helps.

[#3]

Try Alternate States

[#4]

Define the Variables vStartdate and vEnddate.

please find the example Setanalysis expression for the chart

=count({<CreatedDate={"$(= '>=' & date(date#('$(vStartDate)','DD/MM/YYYY')) & '<=' & date(date#('$(vEndDate)','DD/MM/YYYY')))"}>}FeedbackNumber)

[jagan]

HI,

Try like this

=Count({<Date={">=$(=Date(Min(Date)))<=$(=Date(Max(Date)))"}>} MeasureName)

Hope this helps you.

Regards,

Jagan.