Month Year

[joanneandrews]

Good day,

I have created a graph but the X axis is showing the months as 07.16 / 08.16 / 09.16.

I am wanting the X axis to show Jul 16 / Aug 16 / Sep 16.

Any help would be appreciated.

Thank you

[sunny_talwar · Accepted solution]

May be use this as your dimension

Date(FieldName, 'MMM / YY')

[pradosh_thakur]

if dimension is in date format date(field,'MMM YY') 

If string

date(date#(field,MM.YY),'MMM YY')