APEX

Hello

I am building an application that will use Scatter-charts to display values.

I have made a scatter-chart that displays Energy/ day on the Y-axis and temperature on the X-axis. And this works perfectly.

Then I have tried doing a scatter chart that shows Energy/day on the Y-axis and wants the X-axis to display dates.
For instance, I would like to display the energy-consumption for each day 2006-01-01 to 2006-03-01.

But the query for the sql-serie do not accept date-format. I have to convert it to number.

And the scatter charts works almost after that.

The problem is that instead of
20060101 to 20060131 and 20060201 to 20060228 and 20060301 in the X-axis.
I get
20060101 to 20060199 and 20060201 to 20060299 and 20060301.

The program is not treating the X-axes based on date, it is just based on numeric values.

Is there a way to change the flash-scatter chart, so I can use dates on the x-axis.

Here is the sql I use for the serie.
SELECT NULL LINK,
ANL_NR LABEL,
to_number(to_char(DATUM,'YYYYMMDD')) datumnr,
UPPMATT_ENERGI Y_VALUE
FROM PLOT_ENERGI
WHERE ANL_NR = :P2_ANL_NR
and datum between to_date(:P2_FROMDAG,'YYYY-MM-DD')
and to_date(:P2_TOMDAG,'YYYY-MM-DD')

Any help appreciated

Ulf