how to display the in between data?

[#1]

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

for example i have dates like 01/03/2008 to 13/04/2016 .

when i select any dates like 02/07/2010 and 07/08/2013 .so i want display sales  02/07/2008  date to 13/04/2016 date.how?

1)first how to provide the two dates selections at time to the user.

2)after user select any two dates in between dates sales amount also display ?

[#2]

Hi,

Can you share attached exemple what actully you want.

Regards

tripati

[#3]

Hi rajana,this is interview question .let us take example you have Table like

sales,year

100.2008

200,2009

300,2010

400,2011

500,2012

600,2013.

if user select any two years like 2009 and 2012 it will display in between sales.like bellow

200

300

400

500

[sunny_talwar]

Try the attached application:

1) Used two variables (vStart and vEnd) and used them in two different calendar objects.

2) Added a OnInput trigger to both vStart and vEnd to select a range of dates using this expression

='>='&Date(vStart)&'<='&Date(vEnd)