Skip to Content
Former Member
Oct 22, 2008 at 09:39 PM

Year Format


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.