Hello, Couldn't you summarise your data in your query the first place?
eg: select left(datename(month, my_date ),3) +'-'+ datename( year, my_date) as period, count( of something ) as my_count from my_table group by left(datename(month, my_date ),3) +'-'+ datename( year, my_date) ( MS SQL ) which would return Dec-1989 etc? much quicker imo. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, 18 March 2011 12:49 PM To: [email protected] Subject: [cfaussie] CFChart X axis value formatting Hi I have creating line graphs using cf charge and the dates are on the x axis the date values in the sql tables being drawn on in the chart are datetime format and as a result I am having the date and time appearing on the x axis for each point on the chart as their a way I can alter the display format of the values similar what is done using the DateFromat() do that my dates along the x axis only show in a month-year eg "jan-11" rather than "01/01/11 10:55.00AM" Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) [cid:[email protected]] Email: [email protected]<mailto:[email protected]> Website: www.TrackingCentral.com.au<http://www.trackingcentral.com.au/> FREE CALL: 1300 255 990 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
<<inline: image001.gif>>
