Need help to change format of Date in Chart

[42894]

Hi,

I am using CRXI.

I am working on 1 report and i have to change the format of Date in Chart.

In Chart dates are displaying like Jan-2008 but i want to see 01/08. I put Close_date field in my formula ConvertToTimeZone({table1.Close_date}). I used this formula in my chart.I have done grouping on this formula field.

Please help me to change this format of Date.

I would really appreciate your help.

Thanks in advance
Aatman

 

[strtech]

Hi,

Just in case you didn't find the answer, you can use the Month() function in a formula that will convert "Jan" to "01". Then use that formula in the chart.