help

Wed, 12 Sep 2012 05:17:12 GMT

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.

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.

Re: help

whiteline — Wed, 12 Sep 2012 06:04:20 GMT

to cahnge text format use:

date(date#(date, 'DD-MM-YYYY'), 'MM/DD/YYYY') as date

to load dates between add quotes:

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