How do you pull out only month and year from data


No cake for spunky
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.