Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)'