I include the year in report numbers that I produce. My report number format is XXX-YY-XXX. The -YY- is the last two digits of the year, 2014 is recorded as -14-. I have a calculation the gives me my report number but the date shows as -2014-. I get the date from the Date function - Year.
Any ideas on how to have the year show as the 2 digits rather than the full year?