I am extracting a year from a date using the year formula however my answer is reporting in YYYY.00 format. I know I can change it in the format field but I do not understand why it would appear in that format to begin with.
I want just the last two digest of the year to appear in my report (eg. 08) and am using ' right (@year,2) '
However, this syntax required me to change the @year to ' totext (year ) and thus the format field when back to YYYY.00.
Due to other formulas I am unable to change the number field at the report level to drop the .00.
Any help.