Hi Guys,

I have one of those cases where the Fiscal Year End changed and creates the situation where the year is suffixed with an "A" and I'm trying to get the FR to show me which year has been selected on the toolbar.

I'm using the function =VALUE(FYEAR()) but it doesn't differentiate between FYs 2013 and 2013A, returning 2013 for both.

Should I be using something else ?

Pete

Hi Pete,

The VALUE() function converts a string to a number. Hence "2013-" and "2013A" both convert to the number 2013. If you want them to be different, then get rid of the VALUE() around FYEAR() and deal with the text string.

Thanks Andrew,

In a previous instance I was using it in a calculation and put the VALUE() around it but in this instance I actually need it to be text and even though I looked at it a million times, never saw the VALUE() part, just looked right past it <geez>.

Thanks for the rescue again, Pete