|
 Date Format |
| Posted by ilharess on Jan-05-2009 09:54 |
|
Hi.. I was wondering if anyone could help me with this problem.. I am creating a multiple line chart.. It's a monthly report for bonds.. Anyways.. I'm trying to figure out how to format the date for the label.. I get my data from an SQL database.. and the dates are in datetime format.. Right now all I get for the label is eg: 2005-12-31 12.00.00.. I want to format it to eg: Dec 2005..
Can anyone help me..? Thanx in advance.. |
| Re: Date Format |
| Posted by ilharess on Jan-05-2009 10:00 |
|
| BTW.. I'm using Coldfusion and Javascript for this.. |
| Re: Date Format |
| Posted by Peter Kwan on Jan-05-2009 18:46 |
|
HI ilharess,
If you are using a label based x-axis (the x-axis is configured using Axis.setLabels), you may just get the date as "Dec 2005" from your database. (The SQL should allow you to format the date.)
Alternatively, if your database query return ColdFusion DateTime values, you may try:
c.xAxis().setLabels2(myDateTimeArray, "{value|mmm yyyy}");
Hope this can help.
Regards
Peter Kwna |
| Re: Date Format |
| Posted by ilharess on Jan-05-2009 18:53 |
|
Hi Peter,
Thank you for the help.. It's working fine now.. Still getting used to ChartDirector..
Thanks again!..~
Regards,
ilharess |
|
Forum Home
Search
Message List
Post Message