Date formatting, help!

[Giannni]

Hi,
Please, help!
How can I format dates in category axes?
I try to do it with this code:
ChartSpace.Charts(0).Axes
(c.chAxisPositionCategory).NumberFormat = "dd mmm"
but all that I get is "invalid parameter".

If I write this:
dim mmm
mmm = ChartSpace.Charts(0).Axes
(c.chAxisPositionCategory).NumberFormat
response.write mmm

I get "General"

and then if I write:
ChartSpace.Charts(0).Axes
(c.chAxisPositionCategory).NumberFormat = "General"

get another time "invalid parameter"!!!
Thanks!!

 

[Alvin Bruney]

This is what you need
[snip]NumberFormat = "MM/DD/YY"