Date format

[phlk]

Hi,

Data in database is stored like this: dd-mm-yyyy.

but x-axis labels show mm/dd/yyyy.

Why, and is there anyway to change that?

Kind regards

Peter Halkier

[saptarshi]

Hello,

 

 

 

FusionCharts itself does not format any data passed to it by the XML.

 

 

 

Could you please check if the database is somehow formatting the data while converting it to XML?

 

 

 

Hope this helps.

[phlk]

Hi and thanks for getting back to me.

That is really weird! I don't see how that could happen... when I run my SQL in e.g. Toad I see the exact data stored in DB and the data is stored like this: 21-06-2008 but that will be presented in charts x-axis like this 06/21/2008.

How would the DB be formatting anything?

Kind regards

Peter

[Guest Rajroop]

Hello Peter,

 

 

 

FusionCharts does not integrate with the database directly in any case. In this instance, while using DataXML/DataURL method, you are probably using an intermediate page that generates the XML dynamically from the database.

 

 

 

Could you please check the date formatting method(DateFormatter class etc.) used in the intermediate page?

 

 

 

I hope this is useful.