datetime - Format date on x-axis in cfchart -

I want to format the date on x-axis of my cfchart as mm / yyyy, as the full data value Contrary to the return of SQL Server (yyyy-mm-dd hh: mm: ss).

How do I do this?

I have not dealt with it in a while, but I remember that the date field is special " Saferch for clean things "processing in the loop. Therefore, the query given through the query will be done for the query q and the date field Thedate loop, your date value will be changed with the synchronized date values. Something like this:

  & lt; Cfloop = "1" = "# q.recordcount #" index = "i" & gt; & Lt; Cfset q.thedate [i] = datformat (q.thedate [i], 'mm / yyyy') & gt; & Lt; / Cfloop & gt;  

Depending on what your data looks like, you want to make further changes, such as sorting of records with questions of questions, etc.