I trying to build a table for use in a line graph. My data is daily and I want to present the aggregated data across MMYYYY on the line graph (X Axis). The columns are aggregated to the Month so I want to order the columns by Month/Year. For example: If I choose a date range from 3/1/2005 to 2/28/2006. I would like to have my columns ordered 3/2005 4/2005 ... 12/2005 1/2006 2/2006 etc.


Any tips on doing this?

Paul, if your dates are smartdates, then
just reformat them. a daily date will compress nicely into a monthly aggregate.
SORTDATE/MtYY = DATE;
Jun 2005, Jul 2005
or some other format
SORTDATE/YYM = DATE ;
experiment till you find the format you like.
If your dates aren't smartdates, then convert them.