Another date formating issue
i want date appear in mmm-dd format - keep getting full odbc date format
my query:
<cfquery name="monthlychart" datasource="2onboard">
select distance, time, walkdate
from bockwalk
where month(walkdate)=#month(now())# , year(walkdate)=#year(now())#
</cfquery>
my cfchart:
<cfchart format="swf"
style="/xml/dailydistancegraphs.xml"
chartheight="175"
chartwidth="575"
showlegend="no"
showborder="yes"
show3d="no"
foregroundcolor="000000"
scalefrom="0"
yaxistitle="mileage">
<cfchartseries type="bar"
query="monthlychart"
valuecolumn="distance"
itemcolumn="walkdate"
seriescolor="ff0000">
</cfchartseries>
</cfchart>
i've tried formating xml file
part of xml file
<xaxis>
<labelstyle ismultiline="false" orientation="vertical" />
<labelformat style="shortdate" pattern="mmm-dd" />
</xaxis>
my query:
<cfquery name="monthlychart" datasource="2onboard">
select distance, time, walkdate
from bockwalk
where month(walkdate)=#month(now())# , year(walkdate)=#year(now())#
</cfquery>
my cfchart:
<cfchart format="swf"
style="/xml/dailydistancegraphs.xml"
chartheight="175"
chartwidth="575"
showlegend="no"
showborder="yes"
show3d="no"
foregroundcolor="000000"
scalefrom="0"
yaxistitle="mileage">
<cfchartseries type="bar"
query="monthlychart"
valuecolumn="distance"
itemcolumn="walkdate"
seriescolor="ff0000">
</cfchartseries>
</cfchart>
i've tried formating xml file
part of xml file
<xaxis>
<labelstyle ismultiline="false" orientation="vertical" />
<labelformat style="shortdate" pattern="mmm-dd" />
</xaxis>
you can reformat date before chart so:
More discussions in ColdFusion
adobe
Comments
Post a Comment