changing date format in a graph

[balllian]

Help

i have an issue with a graph im using. The dates are appearing as dd/mm/yyyy. is there a way of changing their appearance so that they appear as mm/yy instead.

I understnd that you can chnage individual ones by Edit Axis label but as this is going to be a rolling graph and dont want to be doing this on and on going basis.

Thanks in advance

 

[IanWaterman]

Replace date with a formula

totext(month(datefield),"00",0,"")&"/"&
totext((year(datefield)-2000),"00",0,"")

Use this formula in your chart.

This will only work for months in same year, may be better to reverse


totext((year(datefield)-2000),"00",0,"")&"/"&totext(month(datefield),"00",0,"")

this will sort correctly over two years.

Ian