Input Data from Calendar and using the same get the data from the SQL tables

[#1]

How do I get the matching data based on the input passed from the Input Fields. For example if have start and end date as my input how do i filter the records from the main data for the inputted values.

[#2]

Hi

Since i am not able to open the file is there anyway you can send me the script file.

Thanks for the help.  The screenshot which you sent me is what i am expecting.

Ramesh

[MayilVahanan]

HI

In script:

Load * Inline

[

ID,Sales,Date

1,1000,10/01/2012

2,1000,10/02/2012

3,500,10/03/2012

4,600,10/04/2012

];

Straight table:

1.Date as Dimension

2.=Sum({<Date = {'>=$(=Date(vStart))<=$(=Date(vEnd))'}>}Sales) as expression

Hope it helps