Date Ordering in Charts

I have a chart that has MM/YYYY for tics on the X-axis. The problem is that
January and October are being positioned next to each other...
1/2005...10/2005...2/2005...3/2005
Is there any way to tell the chart to order these by date rather than by
string value?What I've done is create two more columns in your dataset for the date the
mm/yyy stand for (one with the month and one with the year using the month
and year functions). Then group and sort by year and then month. That should
put your October after September instead of January.
"Todd Bright" wrote:
> I have a chart that has MM/YYYY for tics on the X-axis. The problem is that
> January and October are being positioned next to each other...
> 1/2005...10/2005...2/2005...3/2005
> Is there any way to tell the chart to order these by date rather than by
> string value?|||Thanks. I thought RS was doing some kind of ordering, but in fact it was me
just being stupid. I was doing what you mentioned, but I didn't realize that
I was using the same field name to mean different things.
"Tina" wrote:
> What I've done is create two more columns in your dataset for the date the
> mm/yyy stand for (one with the month and one with the year using the month
> and year functions). Then group and sort by year and then month. That should
> put your October after September instead of January.
> "Todd Bright" wrote:
> > I have a chart that has MM/YYYY for tics on the X-axis. The problem is that
> > January and October are being positioned next to each other...
> >
> > 1/2005...10/2005...2/2005...3/2005
> >
> > Is there any way to tell the chart to order these by date rather than by
> > string value?sql