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>

you can reformat date before chart so:


More discussions in ColdFusion


adobe

Comments

Popular posts from this blog

opencv3, tbb and rasp pi 2 - Raspberry Pi Forums

small ethernet problem - Raspberry Pi Forums

Multithumb configuration params not working? - Joomla! Forum - community, help and support