I suspect this is a format issue although I have not found one that works.
I have day month and year and I want to convert it to a date with year and month only (MMYYYY). Because having day in makes the charts look horrible and give no useful information.
Anyone know how to do this.