cfchart and the x axis

[beavermjr]

I'm working on a weight loss application and am trying out the CFCHART tag for
the first time. I'm charting weight over time. In working with the chart, I've
noticed 2 things with regards to the x axis.

1. I need to format the date items so the format is "5-16-2005" rather than
the default "2005-5-16 00:00:00.0" as extracted from an access database.

2. Weight has not been recorded on a consistant basis. There are sporatic
recordings with gaps of up to a month before I started recording daily. How do
I get the points on the x access to space according to date rather than
automatically putting uniform spacing between data points?

I am using MX 6.. Is this functionality available to me or would I need to use
version 7?

[jorgepino]

#DateFormat(todayDate, "mm-dd-yyyy")#

[beavermjr]

How would I use the date format command in the following line of code:

<cfchartseries type="line" serieslabel="Present Weight" query="weight2" itemcolumn="date" valuecolumn="weight">

[jorgepino]

<cfchartseries
type="line"
serieslabel="Present Weight"
query="weight2"
itemcolumn="#DateFormat(Date, "mm-dd-yyyy")# "
valuecolumn="weight">

[beavermjr]

thanks much that helps me out. any word on #2?

[beavermjr]

id date format onl;y available in MX 7? mx 6 doesn't like it.

[Symantec]

the values itemcolumn and valuecolumn do not accept functions or evaluation of
variables from query terms. Im not sure you might be able use a static
variables but that would be pretty pointless.

<cfchartseries type="line" serieslabel="Present Weight">
<cfloop query="weight2">
<cfchartdata item="#dateformat(date, "mm-dd-yyyy")#" value="#weight#">
</cfloop>
</cfchartseries>