Showing month in the chart

[russula]

Hello everybody!
Sorry if it is already discussed but I didn't managed to find such topic.
I have data per month and need to show it in the chart. The problem is that I have only month number and I should show date for last 6 month. For example, in February I need to show date for 8, 9, 10, 11, 12 and 1 month etc.... In the chart I need to show the month name and year (August 2006 for 8 for example). The problem is with the format and order. If the format of "month-year" is string, the data are ordered alphabetically, if format of "month-year" is Date, I have to put Day such a "01 August 2006", but I don't need this Day number. I can't leave "in original order" because the data are grouped and will be repeated several times.
So how to remove this Day from the date format in the chart? I didn't find options "Format" as it can be done for normal field in the report in this case? Have you any idea?

Thanks in advance.

 

[Madawc]

Try ToText({your.date}, "yyyy MM", or ToText({your.date}, "yy MM" if you have no dates before 2000.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods change between versions, and higher versions have extra options.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10