5 Replies Latest reply: Jul 31, 2018 1:35 PM by Sunny Talwar

# Convert YYYY to YY on a calculated field

I currently have the following calculated field 'Q' & Ceil(Month([Activity Month])/3) &'  '& 'FY'&((Year([Activity Month]))+1) which purpose is to show the data in the following way Q1 FY18 or FY19 according to the year but instead it's showing as FY2018 or FY2019 i need the best way of converting the year from YYYY to YY so it could show as FY18 or FY19 depending on what is shown on the Activity Month Table.

• ###### Re: Convert YYYY to YY on a calculated field

May be this

'Q' & Ceil(Month([Activity Month])/3) &'  '& 'FY'& Right(((Year([Activity Month]))+1), 2)

• ###### Re: Convert YYYY to YY on a calculated field

Thanks for the assistance

• ###### Re: Convert YYYY to YY on a calculated field

I also need the Q to start in April which will be month #4 is there any solution which could be applied on the calculated field in the same function above??

• ###### Re: Convert YYYY to YY on a calculated field

May be this

'Q' & Ceil(Month(AddMonths([Activity Month], -3))/3) &'  '& 'FY'& Right(((Year(AddMonths([Activity Month], -3)))+1), 2)

• ###### Re: Convert YYYY to YY on a calculated field

Or this

'Q' & Ceil(Month(AddMonths([Activity Month], 9))/3) &'  '& 'FY'& Right(((Year(AddMonths([Activity Month], 9)))+1), 2)