Date range at data loading time

[#1]

i am trying to load data from Qvd to another Qvd with statement like

Load

where date>=$(vstartdate) and date <=$(venddate)

but i am not able to load data between two date which i m trying to load .

also  i m facing problem that the date column contain date as 24-08-2012.

how can i change it to mm/dd/yyyy.

Actually i have a qvd which have every day date from where i m trying to extract monthly data by passing start and end date from input box.

can any one also suggest how to pick last day of month data for each month in chart.

Thanks.

[manojkvrajan]

Try to change the format of fields declared inside the variables - vStartdate and venddate  to DD/MM/YYYY and it should work. Please upload a sample qvw and see if I can be of any help.

[#3]

Here is sample data from where i want to load data between 4-3-2012 to 8-3-2012, also i want to load month column using ,month(date)

and i want to select last row of month in chart.