Would it be
LEFT (FYDATE, LEN(FYDATE) - 8) ==> spits out the month
Then conoctacate the month and the year from the LEFT(FYDATE, 4).
I'm having parenthesis issues when trying the LEFT(FYDATE, LEN(FYDATE) - 8)?
Oh I was accidentally using a LEN data field I happened to have in my data instead of LEN the function...
Thank you! Much quicker than my version.